:Base la1n40en.hlp>Steps
:Title Approach Help
:Index Lotus Chart Help=lc1n20en.hlp
:Index LotusScript IDE Help=lsen30en.hlp
:Index LotusScript Language Help=lsln30en.hlp
:Index Approach LotusScript Reference Help=lasn40en.hlp
:Index Freelance Graphics LotusScript Reference Help=fl2c10en.hlp
:Index Word Pro LotusScript Reference Help=wp0n70en.hlp
:Index TeamMail Help=tm1n10en.hlp
:Index Lotus Customer Support Help=cs1n40en.hlp
1 Getting Started
2 Using Help=H_USING_HELP_REF@la1n40en.hlp>Overview
2 Planning a Database
3 Why build a database?=H_WHY_BUILD_A_DATABASE_REF@la1n40en.hlp>Overview
3 What will a database do for you?=H_WHAT_WILL_A_DATABASE_DO_FOR_YOU_REF@la1n40en.hlp>Overview
3 What questions will you ask the database?=H_WHAT_QUESTIONS_WILL_YOU_ASK_THE_DATABASE_REF@la1n40en.hlp>Overview
3 What kind of data?=H_WHAT_KIND_OF_DATA_REF@la1n40en.hlp>Overview
3 Identify main ideas and group fields under them=H_IDENTIFY_MAIN_IDEAS_AND_GROUP_FIELDS_UNDER_THEM_REF@la1n40en.hlp>Overview
3 Make connections between the groups=H_MAKE_CONNECTIONS_BETWEEN_THE_GROUPS_REF@la1n40en.hlp>Overview
3 Check for redundant information=H_CHECK_FOR_REDUNDANT_INFORMATION_REF@la1n40en.hlp>Overview
3 Use SmartMasters=H_USE_SMARTMASTERS_REF@la1n40en.hlp>Overview
3 Build the database in Approach=H_BUILD_THE_DATABASE_IN_APPROACH_REF@la1n40en.hlp>Overview
2 Did You Know. . .
3 Browse is for data, Design is for style=H_BROWSE_IS_FOR_DATA_DESIGN_IS_FOR_STYLE_REF@la1n40en.hlp>Overview
3 Approach saves data automatically=H_APPROACH_SAVES_DATA_AUTOMATICALLY_REF@la1n40en.hlp>Overview
3 A sort is not a find=H_A_SORT_IS_NOT_A_FIND_REF@la1n40en.hlp>Overview
3 Select Print Preview to see report summaries=H_SELECT_PRINT_PREVIEW_TO_SEE_REPORT_SUMMARIES_REF@la1n40en.hlp>Overview
1 Top 10 Tasks
2 Importing and Exporting Data
3 Importing Data
4 Importing data into databases=H_IMPORTING_DATA_INTO_DATABASES_STEPS@la1n40en.hlp>Steps
4 Opening databases created in other applications=H_OPENING_DATABASES_CREATED_IN_OTHER_APPLICATIONS_STEPS@la1n40en.hlp>Steps
4 Creating databases from spreadsheets=H_CREATING_DATABASES_FROM_SPREADSHEETS_STEPS@la1n40en.hlp>Steps
4 Creating databases from delimited text files=H_CREATING_DATABASES_FROM_DELIMITED_TEXT_FILES_STEPS@la1n40en.hlp>Steps
4 Creating databases from fixed-length text files=H_CREATING_DATABASES_FROM_FIXEDLENGTH_TEXT_FILES_STEPS@la1n40en.hlp>Steps
4 Importing Approach files=H_IMPORTING_APPROACH_FILES_STEPS@la1n40en.hlp>Steps
4 Mapping fields=H_MAPPING_FIELDS_REF@la1n40en.hlp>Overview
4 Pasting pictures in fields=H_PASTING_PICTURES_IN_FIELDS_STEPS@la1n40en.hlp>Steps
3 Exporting Data
4 Exporting data from Approach=H_EXPORTING_DATA_FROM_APPROACH_STEPS@la1n40en.hlp>Steps
4 Copying PicturePlus pictures to a file=H_COPYING_PICTUREPLUS_PICTURES_TO_A_FILE_STEPS@la1n40en.hlp>Steps
2 Creating Databases
3 Creating a new database from scratch=H_CREATING_A_NEW_DATABASE_FROM_SCRATCH_STEPS@la1n40en.hlp>Steps
3 Creating a new database with a set of ready-to-use fields=H_CREATING_A_NEW_DATABASE_WITH_A_SET_OF_READYTOUSE_FIELDS_STEPS@la1n40en.hlp>Steps
3 Creating a new database that is a ready-to-use application=H_CREATING_A_NEW_DATABASE_THAT_IS_A_READYTOUSE_APPLICATION_STEPS@la1n40en.hlp>Steps
3 Opening databases created in other applications=H_OPENING_DATABASES_CREATED_IN_OTHER_APPLICATIONS_STEPS@la1n40en.hlp>Steps
3 Creating databases from spreadsheets=H_CREATING_DATABASES_FROM_SPREADSHEETS_STEPS@la1n40en.hlp>Steps
3 Creating databases from delimited text files=H_CREATING_DATABASES_FROM_DELIMITED_TEXT_FILES_STEPS@la1n40en.hlp>Steps
3 Creating databases from fixed-length text files=H_CREATING_DATABASES_FROM_FIXEDLENGTH_TEXT_FILES_STEPS@la1n40en.hlp>Steps
3 Creating custom SmartMasters=H_CREATING_CUSTOM_SMARTMASTERS_STEPS@la1n40en.hlp>Steps
3 Mapping fields=H_MAPPING_FIELDS_REF@la1n40en.hlp>Overview
2 Creating and Formatting Fields
3 Defining Fields for Databases
4 Overview: Types of fields=H_TYPES_OF_FIELDS_OVER@la1n40en.hlp>Overview
4 Adding fields to a database=H_ADDING_FIELDS_TO_A_DATABASE_STEPS@la1n40en.hlp>Steps
4 Writing formulas for calculated fields=H_WRITING_FORMULAS_FOR_CALCULATED_FIELDS_STEPS@la1n40en.hlp>Steps
4 Calculating a summary across records=H_CALCULATING_A_SUMMARY_ACROSS_RECORDS_STEPS@la1n40en.hlp>Steps
4 Editing fields of a database=H_EDITING_FIELDS_OF_A_DATABASE_STEPS@la1n40en.hlp>Steps
4 Specifying a key field for a Paradox database=H_SPECIFYING_A_KEY_FIELD_FOR_A_PARADOX_DATABASE_STEPS@la1n40en.hlp>Steps
4 Deleting fields from a database=H_DELETING_FIELDS_FROM_A_DATABASE_STEPS@la1n40en.hlp>Steps
3 Displaying Fields in Views
4 Overview: Fields=H_FIELDS_OVER@la1n40en.hlp>Overview
4 Adding fields to a view=H_ADDING_FIELDS_TO_A_VIEW_STEPS@la1n40en.hlp>Steps
4 Displaying fields as scrolling lists=H_DISPLAYING_FIELDS_AS_SCROLLING_LISTS_STEPS@la1n40en.hlp>Steps
4 Displaying fewer values in a scrolling list=H_DISPLAYING_FEWER_VALUES_IN_A_SCROLLING_LIST_STEPS@la1n40en.hlp>Steps
4 Displaying descriptive values in a scrolling list=H_DISPLAYING_DESCRIPTIVE_VALUES_IN_A_SCROLLING_LIST_STEPS@la1n40en.hlp>Steps
4 Displaying fields as check boxes=H_DISPLAYING_FIELDS_AS_CHECK_BOXES_STEPS@la1n40en.hlp>Steps
4 Displaying fields as radio buttons=H_DISPLAYING_FIELDS_AS_RADIO_BUTTONS_STEPS@la1n40en.hlp>Steps
4 Rearranging a set of radio buttons or check boxes=H_REARRANGING_A_SET_OF_RADIO_BUTTONS_OR_CHECK_BOXES_STEPS@la1n40en.hlp>Steps
2 Entering and Editing Data
3 Adding, Deleting, and Hiding Records
4 Adding new records=H_ADDING_NEW_RECORDS_STEPS@la1n40en.hlp>Steps
4 Duplicating records=H_DUPLICATING_RECORDS_STEPS@la1n40en.hlp>Steps
4 Deleting specific records=H_DELETING_SPECIFIC_RECORDS_STEPS@la1n40en.hlp>Steps
4 Deleting a found set of records=H_DELETING_A_FOUND_SET_OF_RECORDS_STEPS@la1n40en.hlp>Steps
4 Deleting all records=H_DELETING_ALL_RECORDS_STEPS@la1n40en.hlp>Steps
4 Hiding records=H_HIDING_RECORDS_STEPS@la1n40en.hlp>Steps
4 Showing hidden records=H_SHOWING_HIDDEN_RECORDS_STEPS@la1n40en.hlp>Steps
3 Entering Data in Fields
4 Selecting fields=H_SELECTING_FIELDS_STEPS@la1n40en.hlp>Steps
4 Entering text in text or memo fields=H_ENTERING_TEXT_IN_TEXT_OR_MEMO_FIELDS_STEPS@la1n40en.hlp>Steps
4 Entering values in numeric fields=H_ENTERING_VALUES_IN_NUMERIC_FIELDS_STEPS@la1n40en.hlp>Steps
4 Entering values in Boolean fields=H_ENTERING_VALUES_IN_BOOLEAN_FIELDS_STEPS@la1n40en.hlp>Steps
4 Entering dates in date fields=H_ENTERING_DATES_IN_DATE_FIELDS_STEPS@la1n40en.hlp>Steps
4 Entering times in time fields=H_ENTERING_TIMES_IN_TIME_FIELDS_STEPS@la1n40en.hlp>Steps
4 Duplicating a value from the last record modified=H_DUPLICATING_VALUES_FROM_THE_LAST_RECORD_MODIFIED_STEPS@la1n40en.hlp>Steps
4 Selecting from a drop-down box=H_SELECTING_FROM_A_DROPDOWN_BOX_STEPS@la1n40en.hlp>Steps
4 Selecting radio buttons or check boxes=H_SELECTING_RADIO_BUTTONS_OR_CHECK_BOXES_STEPS@la1n40en.hlp>Steps
4 Entering the same data into many records=H_ENTERING_THE_SAME_DATA_INTO_MANY_RECORDS_STEPS@la1n40en.hlp>Steps
4 Pasting pictures in fields=H_PASTING_PICTURES_IN_FIELDS_STEPS@la1n40en.hlp>Steps
4 Drawing in PicturePlus fields=H_DRAWING_IN_PICTUREPLUS_FIELDS_STEPS@la1n40en.hlp>Steps
3 Moving to Another Record
4 Moving through records one record at a time=H_MOVING_ONE_RECORD_AT_A_TIME_STEPS@la1n40en.hlp>Steps
4 Moving to the first or last record=H_MOVING_TO_THE_FIRST_OR_LAST_RECORD_STEPS@la1n40en.hlp>Steps
4 Moving to a specific record=H_MOVING_TO_A_SPECIFIC_RECORD_STEPS@la1n40en.hlp>Steps
3 Checking Spelling
4 Checking spelling=H_RUNNING_THE_SPELLING_CHECKER_STEPS@la1n40en.hlp>Steps
4 Editing the user dictionary=H_EDITING_THE_USER_DICTIONARY_STEPS@la1n40en.hlp>Steps
4 Changing to another main dictionary=H_CHANGING_TO_ANOTHER_MAIN_DICTIONARY_STEPS@la1n40en.hlp>Steps
4 Setting options for checking spelling=H_SETTING_OPTIONS_FOR_CHECKING_SPELLING_STEPS@la1n40en.hlp>Steps
3 Finding and Replacing Text
4 Finding text=H_FINDING_TEXT_STEPS@la1n40en.hlp>Steps
4 Replacing text=H_REPLACING_TEXT_STEPS@la1n40en.hlp>Steps
2 Laying Out and Styling Views
3 Overview: InfoBox=H_INFOBOX_OVER@la1n40en.hlp>Overview
3 Working with Named Styles
4 Overview: Working with named styles=H_WORKING_WITH_NAMED_STYLES_OVER@la1n40en.hlp>Overview
4 Defining new named styles=H_DEFINING_NEW_NAMED_STYLES_STEPS@la1n40en.hlp>Steps
4 Applying named styles=H_APPLYING_NAMED_STYLES_STEPS@la1n40en.hlp>Steps
4 Applying a named style from the InfoBox=H_APPLYING_A_NAMED_STYLE_FROM_THE_INFOBOX_STEPS@la1n40en.hlp>Steps
4 Copying named styles=H_COPYING_NAMED_STYLES_STEPS@la1n40en.hlp>Steps
4 Editing named styles=H_EDITING_NAMED_STYLES_STEPS@la1n40en.hlp>Steps
4 Deleting named styles=H_DELETING_NAMED_STYLES_STEPS@la1n40en.hlp>Steps
3 Adding Objects to the Background of a View
4 Drawing geometric objects=H_DRAWING_GEOMETRIC_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Adding text blocks=H_ADDING_TEXT_BLOCKS_STEPS@la1n40en.hlp>Steps
4 Adding multiple objects to a view=H_ADDING_MULTIPLE_OBJECTS_TO_A_VIEW_STEPS@la1n40en.hlp>Steps
4 Pasting pictures in views=H_PASTING_PICTURES_IN_VIEWS_STEPS@la1n40en.hlp>Steps
4 Inserting dates or times=H_INSERTING_DATES_OR_TIMES_STEPS@la1n40en.hlp>Steps
4 Adding buttons to run macros=H_ADDING_MACRO_BUTTONS_STEPS@la1n40en.hlp>Steps
3 Changing Objects and Text
4 Applying properties from another object (Fast Format)=H_APPLYING_PROPERTIES_FROM_ANOTHER_OBJECT_STEPS@la1n40en.hlp>Steps
4 Selecting objects=H_SELECTING_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Resizing objects=H_RESIZING_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Moving objects=H_MOVING_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Selecting text in text blocks=H_SELECTING_TEXT_IN_A_TEXT_BLOCK_STEPS@la1n40en.hlp>Steps
4 Cutting or copying objects or text=H_CUTTING_OR_COPYING_OBJECTS_OR_TEXT_STEPS@la1n40en.hlp>Steps
4 Changing the width of lines or borders=H_CHANGING_THE_WIDTH_OF_LINES_OR_BORDERS_STEPS@la1n40en.hlp>Steps
4 Creating partial borders=H_CREATING_PARTIAL_BORDERS_STEPS@la1n40en.hlp>Steps
4 Making objects and views transparent=H_MAKING_OBJECTS_AND_VIEWS_TRANSPARENT_STEPS@la1n40en.hlp>Steps
4 Putting objects and fields in the tab order=H_PUTTING_OBJECTS_AND_FIELDS_IN_THE_TAB_ORDER_STEPS@la1n40en.hlp>Steps
4 Changing the tab order on views=H_CHANGING_THE_TAB_ORDER_ON_VIEWS_STEPS@la1n40en.hlp>Steps
3 Working with More Than One Object at a Time
4 Grouping and ungrouping objects=H_GROUPING_AND_UNGROUPING_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Changing the order of overlapping objects=H_CHANGING_THE_ORDER_OF_OVERLAPPING_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Aligning and distributing objects=H_ALIGNING_AND_DISTRIBUTING_OBJECTS_STEPS@la1n40en.hlp>Steps
3 Editing Views
4 Naming views=H_NAMING_VIEWS_AND_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Selecting a main database for a view=H_SELECTING_A_MAIN_DATABASE_FOR_A_VIEW_STEPS@la1n40en.hlp>Steps
4 Changing the menu for a view=H_CHANGING_THE_MENU_FOR_A_VIEW_STEPS@la1n40en.hlp>Steps
4 Hiding views=H_HIDING_VIEWS_STEPS@la1n40en.hlp>Steps
4 Redisplaying hidden views=H_REDISPLAYING_HIDDEN_VIEWS_STEPS@la1n40en.hlp>Steps
4 Showing more of the view by hiding its margins=H_SHOWING_MORE_OF_THE_VIEW_BY_HIDING_ITS_MARGINS_STEPS@la1n40en.hlp>Steps
4 Changing the width of the view border=H_CHANGING_THE_WIDTH_OF_LINES_OR_BORDERS_STEPS@la1n40en.hlp>Steps
4 Creating partial borders for views=H_CREATING_PARTIAL_BORDERS_STEPS@la1n40en.hlp>Steps
4 Duplicating views=H_DUPLICATING_VIEWS_STEPS@la1n40en.hlp>Steps
4 Deleting views=H_DELETING_VIEWS_STEPS@la1n40en.hlp>Steps
4 Deleting elements of a view=H_DELETING_ELEMENTS_OF_A_VIEW_STEPS@la1n40en.hlp>Steps
4 Adding fields to a view=H_ADDING_FIELDS_TO_A_VIEW_STEPS@la1n40en.hlp>Steps
2 Joining Databases
3 Joining database files=H_JOINING_DATABASE_FILES_STEPS@la1n40en.hlp>Steps
3 Setting options for a join=H_SETTING_OPTIONS_FOR_A_JOIN_STEPS@la1n40en.hlp>Steps
3 Making calculated fields available for joins=H_MAKING_CALCULATED_FIELDS_AVAILABLE_FOR_JOINS_STEPS@la1n40en.hlp>Steps
3 Unjoining database files=H_UNJOINING_DATABASE_FILES_STEPS@la1n40en.hlp>Steps
3 Overview: Joined databases=H_JOINED_DATABASES_OVER@la1n40en.hlp>Overview
3 Overview: Main and detail databases in a view=H_MAIN_AND_DETAIL_DATABASES_IN_A_VIEW_OVER@la1n40en.hlp>Overview
3 Overview: One-to-many, many-to-one, and one-to-one relationships=H_ONE_TO_MANY_MANY_TO_ONE_AND_ONE_TO_ONE_RELATIONSHIPS_OVER@la1n40en.hlp>Overview
3 Overview: Many-to-many relationships=H_MANY_TO_MANY_RELATIONSHIPS_OVER@la1n40en.hlp>Overview
3 Overview: Alias joins=H_ALIAS_JOINS_OVER@la1n40en.hlp>Overview
3 Joining a database to itself (alias join)=H_JOINING_A_DATABASE_TO_ITSELF_STEPS@la1n40en.hlp>Steps
2 Finding Records
3 Overview: The found set=H_THE_FOUND_SET_OVER@la1n40en.hlp>Overview
3 Showing all records=H_SHOWING_ALL_RECORDS_STEPS@la1n40en.hlp>Steps
3 Finding Records Using the Find Assistant
4 Overview: Finding records with the Find Assistant=H_FINDING_RECORDS_WITH_THE_FIND_ASSISTANT_OVER@la1n40en.hlp>Overview
4 Selecting a find type with the Find Assistant=H_SELECTING_A_FIND_TYPE_WITH_THE_FIND_ASSISTANT_REF@la1n40en.hlp>Overview
4 Creating a find condition with the Find Assistant=H_CREATING_A_FIND_CONDITION_WITH_THE_FIND_ASSISTANT_STEPS@la1n40en.hlp>Steps
4 Finding duplicate records with the Find Assistant=H_FINDING_DUPLICATE_RECORDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n40en.hlp>Steps
4 Finding distinct or unique records with the Find Assistant=H_FINDING_DISTINCT_OR_UNIQUE_RECORDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n40en.hlp>Steps
4 Finding the top or lowest values with the Find Assistant=H_FINDING_THE_TOP_OR_LOWEST_VALUES_WITH_THE_FIND_ASSISTANT_STEPS@la1n40en.hlp>Steps
4 Sorting fields with the Find Assistant=H_SORTING_FIELDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n40en.hlp>Steps
3 Finding Records Using Query by Box
4 Finding records using Query by Box=H_FINDING_RECORDS_USING_QUERY_BY_BOX_STEPS@la1n40en.hlp>Steps
4 Overview: Defining find conditions graphically in Query by Box=H_DEFINING_FIND_CONDITIONS_GRAPHICALLY_IN_QUERY_BY_BOX_OVER@la1n40en.hlp>Overview
4 Overview: Multiple find conditions in Query by Box=H_MULTIPLE_FIND_CONDITIONS_IN_QUERY_BY_BOX_OVER@la1n40en.hlp>Overview
3 Finding Records Using a Blank View
4 Creating find requests=H_CREATING_FIND_REQUESTS_STEPS@la1n40en.hlp>Steps
4 Finding records that satisfy multiple conditions (AND)=H_FINDING_RECORDS_THAT_SATISFY_MULTIPLE_CONDITIONS_(AND)_STEPS@la1n40en.hlp>Steps
4 Finding records that satisfy at least one of several conditions (OR)=H_FIND_RECORDS_TO_SATISFY_ONE_OF_SEVERAL_CONDITIONS_(OR)_STEPS@la1n40en.hlp>Steps
4 Finding records with OR conditions in more than one field=H_FINDING_RECORDS_WITH_OR_CONDITIONS_IN_MORE_THAN_ONE_FIELD_STEPS@la1n40en.hlp>Steps
4 Finding text with wildcards=H_FINDING_TEXT_WITH_WILDCARDS_STEPS@la1n40en.hlp>Steps
4 Finding case-sensitive text=H_FINDING_CASESENSITIVE_TEXT_STEPS@la1n40en.hlp>Steps
4 Finding a word that sounds like another=H_FINDING_A_WORD_THAT_SOUNDS_LIKE_ANOTHER_STEPS@la1n40en.hlp>Steps
4 Finding numbers, dates, and times=H_FINDING_NUMBERS_DATES_AND_TIMES_STEPS@la1n40en.hlp>Steps
4 Finding values in a range=H_FINDING_VALUES_IN_A_RANGE_STEPS@la1n40en.hlp>Steps
4 Finding today's date=H_FINDING_TODAYS_DATE_STEPS@la1n40en.hlp>Steps
4 Finding radio button and check box settings=H_FINDING_RADIO_BUTTON_AND_CHECK_BOX_SETTINGS_STEPS@la1n40en.hlp>Steps
4 Finding blank or nonblank fields=H_FINDING_BLANK_OR_NONBLANK_FIELDS_STEPS@la1n40en.hlp>Steps
4 Using If statements to find data=H_USING_IF_STATEMENTS_TO_FIND_DATA_STEPS@la1n40en.hlp>Steps
4 Repeating finds=H_REPEATING_FINDS_STEPS@la1n40en.hlp>Steps
3 Creating Named Finds
4 Naming finds with the Find Assistant=H_NAMING_FINDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n40en.hlp>Steps
4 Naming and reviewing finds with the Find Assistant=H_NAMING_AND_REVIEWING_FINDS_WITH_THE_FIND_ASSISTANT_REF@la1n40en.hlp>Overview
4 Naming finds based on find requests=H_NAMING_FINDS_BASED_ON_FIND_REQUESTS_STEPS@la1n40en.hlp>Steps
4 Editing named finds=H_EDITING_NAMED_FINDS_STEPS@la1n40en.hlp>Steps
4 Copying named finds=H_COPYING_NAMED_FINDS_STEPS@la1n40en.hlp>Steps
4 Deleting named finds=H_DELETING_NAMED_FINDS_STEPS@la1n40en.hlp>Steps
4 Running named finds=H_RUNNING_NAMED_FINDS_STEPS@la1n40en.hlp>Steps
2 Sorting Records
3 Specifying a sort order=H_SPECIFYING_A_SORT_ORDER_STEPS@la1n40en.hlp>Steps
3 Sorting records by a field in a view (Ascending)=H_SORTING_RECORDS_BY_A_FIELD_IN_A_VIEW_ASCENDING_STEPS@la1n40en.hlp>Steps
3 Sorting records by a field in a view (Descending)=H_SORTING_RECORDS_BY_A_FIELD_IN_A_VIEW_DESCENDING_STEPS@la1n40en.hlp>Steps
3 Setting a default sort order for looking at records in Browse=H_SETTING_A_DEFAULT_SORT_ORDER_FOR_RECORDS_IN_BROWSE_STEPS@la1n40en.hlp>Steps
3 Setting a default sort order for a repeating panel=H_SORTING_RECORDS_IN_REPEATING_PANELS_STEPS@la1n40en.hlp>Steps
2 Creating Reports
3 Overview: Reports=H_REPORTS_OVER@la1n40en.hlp>Overview
3 Overview: Report panels=H_REPORT_PANELS_OVER@la1n40en.hlp>Overview
3 Using PowerClick Reporting
4 Creating a PowerClick report with a grand total=H_CREATING_A_POWERCLICK_REPORT_WITH_A_GRAND_TOTAL_STEPS@la1n40en.hlp>Steps
4 Creating a PowerClick report with subtotals for groups=H_CREATING_A_POWERCLICK_REPORT_WITH_SUBTOTALS_FOR_GROUPS_STEPS@la1n40en.hlp>Steps
4 Grouping records in reports=H_GROUPING_RECORDS_IN_REPORTS_STEPS@la1n40en.hlp>Steps
4 Adding summaries to reports=H_ADDING_SUMMARIES_TO_REPORTS_STEPS@la1n40en.hlp>Steps
3 Creating Reports
4 Deciding what new reports look like=H_DECIDING_WHAT_NEW_REPORTS_LOOK_LIKE_REF@la1n40en.hlp>Overview
4 Adding fields to new reports=H_ADDING_FIELDS_TO_NEW_REPORTS_STEPS@la1n40en.hlp>Steps
4 Grouping records in new reports=H_GROUPING_RECORDS_IN_NEW_REPORTS_STEPS@la1n40en.hlp>Steps
4 Adding repeating fields to new repeating panel reports=H_ADDING_REPEATING_FIELDS_TO_NEW_REPEATING_PANEL_REPORTS_STEPS@la1n40en.hlp>Steps
4 Adding summaries to new reports=H_ADDING_SUMMARIES_TO_NEW_REPORTS_STEPS@la1n40en.hlp>Steps
3 Summarizing Data in Reports
4 Adding summaries to reports=H_ADDING_SUMMARIES_TO_REPORTS_STEPS@la1n40en.hlp>Steps
4 Summary calculations=H_SUMMARY_CALCULATIONS_REF@la1n40en.hlp>Overview
4 Choosing which records go into a summary=H_CHOOSING_WHICH_RECORDS_GO_INTO_A_SUMMARY_STEPS@la1n40en.hlp>Steps
4 Moving summaries=H_MOVING_SUMMARIES_STEPS@la1n40en.hlp>Steps
3 Revising Reports
4 Adding fields to reports=H_ADDING_FIELDS_TO_REPORTS_STEPS@la1n40en.hlp>Steps
4 Creating charts in reports=H_CREATING_CHARTS_IN_REPORTS_STEPS@la1n40en.hlp>Steps
4 Selecting, moving, and deleting report panels=H_SELECTING_MOVING_AND_DELETING_REPORT_PANELS_STEPS@la1n40en.hlp>Steps
4 Grouping records in reports=H_GROUPING_RECORDS_IN_REPORTS_STEPS@la1n40en.hlp>Steps
4 Changing the number of columns in reports=H_CHANGING_THE_NUMBER_OF_COLUMNS_IN_REPORTS_STEPS@la1n40en.hlp>Steps
4 Moving and resizing report columns=H_MOVING_AND_RESIZING_REPORT_COLUMNS_STEPS@la1n40en.hlp>Steps
4 Showing missing records in a report=H_SHOWING_ALL_GROUPS_IN_A_REPORT_STEPS@la1n40en.hlp>Steps
3 Printing Reports
4 Reducing or expanding sections of reports when printing=H_PRINTING_REPORTS_STEPS@la1n40en.hlp>Steps
4 Creating title pages for reports=H_CREATING_TITLE_PAGES_FOR_REPORTS_STEPS@la1n40en.hlp>Steps
4 Adding dates, times, or page numbers to reports=H_ADDING_DATES_TIMES_OR_PAGE_NUMBERS_TO_REPORTS_STEPS@la1n40en.hlp>Steps
4 Changing the number of columns in reports=H_CHANGING_THE_NUMBER_OF_COLUMNS_IN_REPORTS_STEPS@la1n40en.hlp>Steps
4 Paginating reports=H_PAGINATING_REPORTS_STEPS@la1n40en.hlp>Steps
2 Previewing and Printing
3 Overview: Printing Approach views=H_PRINTING_APPROACH_VIEWS_OVER@la1n40en.hlp>Overview
3 Downloading data before previewing=H_DOWNLOADING_DATA_BEFORE_PREVIEWING_STEPS@la1n40en.hlp>Steps
3 Previewing views=H_PREVIEWING_VIEWS_STEPS@la1n40en.hlp>Steps
3 Printing views=H_PRINTING_VIEWS_STEPS@la1n40en.hlp>Steps
3 Formatting worksheets or crosstabs for printing=H_FORMATTING_WORKSHEETS_OR_CROSSTABS_FOR_PRINTING_STEPS@la1n40en.hlp>Steps
3 Reducing or expanding sections of reports when printing=H_PRINTING_REPORTS_STEPS@la1n40en.hlp>Steps
3 Closing up extra space between fields=H_CLOSING_EXTRA_SPACE_BETWEEN_FIELDS_STEPS@la1n40en.hlp>Steps
3 Setting objects and fields to slide when printing=H_SETTING_OBJECTS_AND_FIELDS_TO_SLIDE_WHEN_PRINTING_STEPS@la1n40en.hlp>Steps
3 Preventing objects and fields from printing=H_PREVENTING_OBJECTS_AND_FIELDS_FROM_PRINTING_STEPS@la1n40en.hlp>Steps
3 Properties of printers=H_PROPERTIES_OF_PRINTERS_REF@la1n40en.hlp>Overview
3 Specifying the printer, paper, and orientation=H_SPECIFYING_THE_PRINTER_PAPER_AND_ORIENTATION_STEPS@la1n40en.hlp>Steps
3 Printing a list of file properties=H_APPROACH_FILE_PROPERTIES_REF@la1n40en.hlp>Overview
3 Printing a list of database fields=H_PRINTING_A_LIST_OF_DATABASE_FIELDS_STEPS@la1n40en.hlp>Steps
3 Printing a diagram of join relationships=H_PRINTING_A_DIAGRAM_OF_JOIN_RELATIONSHIPS_STEPS@la1n40en.hlp>Steps
3 Printing macros=H_PRINTING_MACRO_COMMANDS_STEPS@la1n40en.hlp>Steps
1 How Do I?
2 Manage Files
3 Create and Open Files
4 Approach file properties=H_APPROACH_FILE_PROPERTIES_REF@la1n40en.hlp>Overview
4 Welcome dialog box: Open an Existing Approach File=H_WELCOME_DIALOG_BOX_OPEN_AN_EXISTING_APPROACH_FILE_REF@la1n40en.hlp>Overview
4 Opening Approach files=H_OPENING_APPROACH_FILES_STEPS@la1n40en.hlp>Steps
4 Creating a new database from scratch=H_CREATING_A_NEW_DATABASE_FROM_SCRATCH_STEPS@la1n40en.hlp>Steps
4 Creating a new database with a set of ready-to-use fields=H_CREATING_A_NEW_DATABASE_WITH_A_SET_OF_READYTOUSE_FIELDS_STEPS@la1n40en.hlp>Steps
4 Creating a new database that is a ready-to-use application=H_CREATING_A_NEW_DATABASE_THAT_IS_A_READYTOUSE_APPLICATION_STEPS@la1n40en.hlp>Steps
4 Opening databases created in other applications=H_OPENING_DATABASES_CREATED_IN_OTHER_APPLICATIONS_STEPS@la1n40en.hlp>Steps
4 Creating databases from spreadsheets=H_CREATING_DATABASES_FROM_SPREADSHEETS_STEPS@la1n40en.hlp>Steps
4 Creating databases from delimited text files=H_CREATING_DATABASES_FROM_DELIMITED_TEXT_FILES_STEPS@la1n40en.hlp>Steps
4 Creating databases from fixed-length text files=H_CREATING_DATABASES_FROM_FIXEDLENGTH_TEXT_FILES_STEPS@la1n40en.hlp>Steps
4 Creating custom SmartMasters=H_CREATING_CUSTOM_SMARTMASTERS_STEPS@la1n40en.hlp>Steps
4 Identifying default directories=H_IDENTIFYING_DEFAULT_DIRECTORIES_STEPS@la1n40en.hlp>Steps
4 Mapping fields=H_MAPPING_FIELDS_REF@la1n40en.hlp>Overview
3 Protect Data, Assign Password Privileges
4 Overview: Passwords=H_PASSWORDS_OVER@la1n40en.hlp>Overview
4 TeamSecurity=H_TEAMSECURITY_REF@la1n40en.hlp>Overview
4 Defining password privileges using Copy=H_DEFINING_PASSWORD_PRIVILEGES_USING_COPY_STEPS@la1n40en.hlp>Steps
4 Defining password privileges using New =H_DEFINING_PASSWORD_PRIVILEGES_USING_NEW_STEPS@la1n40en.hlp>Steps
4 Editing password privileges=H_EDITING_PASSWORD_PRIVILEGES_STEPS@la1n40en.hlp>Steps
4 Deleting groups or users=H_DELETING_GROUPS_OR_USERS_STEPS@la1n40en.hlp>Steps
4 Confirming passwords=H_CONFIRMING_PASSWORDS_STEPS@la1n40en.hlp>Steps
4 Entering data using optimistic record locking=H_ENTERING_DATA_USING_OPTIMISTIC_RECORD_LOCKING_STEPS@la1n40en.hlp>Steps
3 Save, Close, and Delete Files
4 Saving Approach files=H_SAVING_APPROACH_FILES_STEPS@la1n40en.hlp>Steps
4 Saving a copy of an Approach file and a database file=H_SAVING_A_COPY_OF_AN_APPROACH_FILE_AND_A_DATABASE_FILE_STEPS@la1n40en.hlp>Steps
4 Saving a copy of an Approach file only=H_SAVING_A_COPY_OF_AN_APPROACH_FILE_ONLY_STEPS@la1n40en.hlp>Steps
4 Closing Approach files=H_CLOSING_APPROACH_FILES_STEPS@la1n40en.hlp>Steps
4 Deleting files=H_DELETING_FILES_STEPS@la1n40en.hlp>Steps
3 Create Query Files
4 Creating query files in Approach=H_CREATING_QUERY_FILES_IN_APPROACH_STEPS@la1n40en.hlp>Steps
4 Opening query files in Approach=H_OPENING_QUERY_FILES_IN_APPROACH_STEPS@la1n40en.hlp>Steps
4 Saving or exporting data from a query=H_SAVING_OR_EXPORTING_DATA_FROM_A_QUERY_STEPS@la1n40en.hlp>Steps
3 Create an SQL SELECT Statement with the SQL Assistant
4 Overview: Connecting to an SQL or ODBC data source=H_CONNECTING_TO_AN_SQL_OR_ODBC_DATA_SOURCE_OVER@la1n40en.hlp>Overview
4 Installing an ODBC driver =H_INSTALLING_AN_ODBC_DRIVER_STEPS@la1n40en.hlp>Steps
4 Selecting tables for an SQL SELECT statement=H_SELECTING_TABLES_IN_THE_TABLES_TAB_STEPS@la1n40en.hlp>Steps
4 Creating joins for an SQL SELECT statement=H_CREATING_JOINS_IN_THE_JOIN_TAB_STEPS@la1n40en.hlp>Steps
4 Creating find conditions for an SQL SELECT statement=H_CREATING_FIND_CONDITIONS_IN_THE_CONDITION_TAB_STEPS@la1n40en.hlp>Steps
4 Selecting fields for an SQL SELECT statement=H_SELECTING_FIELDS_IN_THE_FIELDS_TAB_STEPS@la1n40en.hlp>Steps
4 Sorting fields for an SQL SELECT statement=H_SORTING_FIELDS_IN_THE_SORT_TAB_STEPS@la1n40en.hlp>Steps
4 Editing SQL statements=H_EDITING_SQL_STATEMENTS_IN_THE_SQL_TAB_STEPS@la1n40en.hlp>Steps
2 Define Fields for a Database
3 Add, Edit, and Delete Database Fields
4 Overview: Types of fields=H_TYPES_OF_FIELDS_OVER@la1n40en.hlp>Overview
4 Adding fields to a database=H_ADDING_FIELDS_TO_A_DATABASE_STEPS@la1n40en.hlp>Steps
4 Writing formulas for calculated fields=H_WRITING_FORMULAS_FOR_CALCULATED_FIELDS_STEPS@la1n40en.hlp>Steps
4 Calculating a summary across records=H_CALCULATING_A_SUMMARY_ACROSS_RECORDS_STEPS@la1n40en.hlp>Steps
4 Editing fields of a database=H_EDITING_FIELDS_OF_A_DATABASE_STEPS@la1n40en.hlp>Steps
4 Specifying a key field for a Paradox database=H_SPECIFYING_A_KEY_FIELD_FOR_A_PARADOX_DATABASE_STEPS@la1n40en.hlp>Steps
4 Deleting fields from a database=H_DELETING_FIELDS_FROM_A_DATABASE_STEPS@la1n40en.hlp>Steps
3 Customize Fields for Data Entry
4 Entering data automatically=H_ENTERING_DATA_AUTOMATICALLY_STEPS@la1n40en.hlp>Steps
4 Verifying the accuracy of entered data=H_VERIFYING_THE_ACCURACY_OF_ENTERED_DATA_STEPS@la1n40en.hlp>Steps
4 Setting OLE options for PicturePlus fields=H_SETTING_OLE_OPTIONS_FOR_PICTUREPLUS_FIELDS_STEPS@la1n40en.hlp>Steps
4 Setting data options for a variable field=H_SETTING_DATA_OPTIONS_FOR_A_VARIABLE_FIELD_STEPS@la1n40en.hlp>Steps
2 Add and Edit Fields in Views
3 Display Fields in a View
4 Overview: Fields=H_FIELDS_OVER@la1n40en.hlp>Overview
4 Adding fields to a view=H_ADDING_FIELDS_TO_A_VIEW_STEPS@la1n40en.hlp>Steps
4 Displaying fields as scrolling lists=H_DISPLAYING_FIELDS_AS_SCROLLING_LISTS_STEPS@la1n40en.hlp>Steps
4 Displaying fewer values in a scrolling list=H_DISPLAYING_FEWER_VALUES_IN_A_SCROLLING_LIST_STEPS@la1n40en.hlp>Steps
4 Displaying descriptive values in a scrolling list=H_DISPLAYING_DESCRIPTIVE_VALUES_IN_A_SCROLLING_LIST_STEPS@la1n40en.hlp>Steps
4 Displaying fields as check boxes=H_DISPLAYING_FIELDS_AS_CHECK_BOXES_STEPS@la1n40en.hlp>Steps
4 Displaying fields as radio buttons=H_DISPLAYING_FIELDS_AS_RADIO_BUTTONS_STEPS@la1n40en.hlp>Steps
4 Rearranging a set of radio buttons or check boxes=H_REARRANGING_A_SET_OF_RADIO_BUTTONS_OR_CHECK_BOXES_STEPS@la1n40en.hlp>Steps
3 Format Data in Fields
4 Formatting dates=H_FORMATTING_DATES_STEPS@la1n40en.hlp>Steps
4 Formatting dates as quarters, thirds, and so on=H_FORMATTING_DATES_AS_QUARTERS_THIRDS_AND_SO_ON_STEPS@la1n40en.hlp>Steps
4 Formatting times=H_FORMATTING_TIMES_STEPS@la1n40en.hlp>Steps
4 Formatting numbers=H_FORMATTING_NUMBERS_STEPS@la1n40en.hlp>Steps
4 Formatting data in text fields=H_SETTING_A_FORMAT_FOR_DATA_IN_TEXT_FIELDS_STEPS@la1n40en.hlp>Steps
3 Edit Fields and Their Labels
4 Changing text attributes of labels or data=H_CHANGING_TEXT_ATTRIBUTES_OF_LABELS_OR_DATA_STEPS@la1n40en.hlp>Steps
4 Editing labels=H_EDITING_LABELS_STEPS@la1n40en.hlp>Steps
4 Changing the position of labels=H_CHANGING_THE_POSITION_OF_LABELS_STEPS@la1n40en.hlp>Steps
4 Hiding labels=H_HIDING_LABELS_STEPS@la1n40en.hlp>Steps
4 Closing up extra space between fields=H_CLOSING_EXTRA_SPACE_BETWEEN_FIELDS_STEPS@la1n40en.hlp>Steps
4 Changing the tab order on views=H_CHANGING_THE_TAB_ORDER_ON_VIEWS_STEPS@la1n40en.hlp>Steps
4 Removing fields from the tab order=H_REMOVING_OBJECTS_AND_FIELDS_FROM_THE_TAB_ORDER_STEPS@la1n40en.hlp>Steps
3 Work with PicturePlus Fields
4 Adding PicturePlus fields to a view=H_ADDING_PICTUREPLUS_FIELDS_TO_A_VIEW_STEPS@la1n40en.hlp>Steps
4 Setting OLE options for PicturePlus fields=H_SETTING_OLE_OPTIONS_FOR_PICTUREPLUS_FIELDS_STEPS@la1n40en.hlp>Steps
4 Pasting pictures in fields=H_PASTING_PICTURES_IN_FIELDS_STEPS@la1n40en.hlp>Steps
4 Editing pictures in PicturePlus fields=H_EDITING_PICTURES_IN_PICTUREPLUS_FIELDS_STEPS@la1n40en.hlp>Steps
4 Drawing in PicturePlus fields=H_DRAWING_IN_PICTUREPLUS_FIELDS_STEPS@la1n40en.hlp>Steps
4 Changing display options for a PicturePlus field=H_CHANGING_DISPLAY_OPTIONS_FOR_A_PICTUREPLUS_FIELD_STEPS@la1n40en.hlp>Steps
4 Copying PicturePlus pictures to a file=H_COPYING_PICTUREPLUS_PICTURES_TO_A_FILE_STEPS@la1n40en.hlp>Steps
2 Join Databases
3 Joining database files=H_JOINING_DATABASE_FILES_STEPS@la1n40en.hlp>Steps
3 Setting options for a join=H_SETTING_OPTIONS_FOR_A_JOIN_STEPS@la1n40en.hlp>Steps
4 Making calculated fields available for joins=H_MAKING_CALCULATED_FIELDS_AVAILABLE_FOR_JOINS_STEPS@la1n40en.hlp>Steps
3 Unjoining database files=H_UNJOINING_DATABASE_FILES_STEPS@la1n40en.hlp>Steps
3 Overview: Joined databases=H_JOINED_DATABASES_OVER@la1n40en.hlp>Overview
3 Overview: Main and detail databases in a view=H_MAIN_AND_DETAIL_DATABASES_IN_A_VIEW_OVER@la1n40en.hlp>Overview
3 Overview: One-to-many, many-to-one, and one-to-one relationships=H_ONE_TO_MANY_MANY_TO_ONE_AND_ONE_TO_ONE_RELATIONSHIPS_OVER@la1n40en.hlp>Overview
3 Overview: Many-to-many relationships=H_MANY_TO_MANY_RELATIONSHIPS_OVER@la1n40en.hlp>Overview
3 Overview: Alias joins=H_ALIAS_JOINS_OVER@la1n40en.hlp>Overview
3 Joining a database to itself (alias join)=H_JOINING_A_DATABASE_TO_ITSELF_STEPS@la1n40en.hlp>Steps
2 Work in Design
3 Overview: InfoBox=H_INFOBOX_OVER@la1n40en.hlp>Overview
3 Customize the Design Environment
4 Showing the grid to help you design views=H_SHOWING_THE_GRID_TO_HELP_YOU_DESIGN_VIEWS_STEPS@la1n40en.hlp>Steps
4 Snapping objects to the grid=H_SNAPPING_OBJECTS_TO_THE_GRID_STEPS@la1n40en.hlp>Steps
4 Showing rulers=H_SHOWING_RULERS_STEPS@la1n40en.hlp>Steps
4 Showing the Tools palette=H_SHOWING_THE_TOOLS_PALETTE_STEPS@la1n40en.hlp>Steps
4 Showing data or field names=H_SHOWING_DATA_OR_FIELD_NAMES_STEPS@la1n40en.hlp>Steps
4 Zooming in and out=H_ZOOMING_IN_AND_OUT_STEPS@la1n40en.hlp>Steps
3 Work with Named Styles
4 Overview: Working with named styles=H_WORKING_WITH_NAMED_STYLES_OVER@la1n40en.hlp>Overview
4 Defining new named styles=H_DEFINING_NEW_NAMED_STYLES_STEPS@la1n40en.hlp>Steps
4 Applying named styles=H_APPLYING_NAMED_STYLES_STEPS@la1n40en.hlp>Steps
4 Applying a named style from the InfoBox=H_APPLYING_A_NAMED_STYLE_FROM_THE_INFOBOX_STEPS@la1n40en.hlp>Steps
4 Copying named styles=H_COPYING_NAMED_STYLES_STEPS@la1n40en.hlp>Steps
4 Editing named styles=H_EDITING_NAMED_STYLES_STEPS@la1n40en.hlp>Steps
4 Deleting named styles=H_DELETING_NAMED_STYLES_STEPS@la1n40en.hlp>Steps
3 Add Objects to the Background of a View
4 Drawing geometric objects=H_DRAWING_GEOMETRIC_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Adding text blocks=H_ADDING_TEXT_BLOCKS_STEPS@la1n40en.hlp>Steps
4 Adding multiple objects to a view=H_ADDING_MULTIPLE_OBJECTS_TO_A_VIEW_STEPS@la1n40en.hlp>Steps
4 Pasting pictures in views=H_PASTING_PICTURES_IN_VIEWS_STEPS@la1n40en.hlp>Steps
4 Inserting dates or times=H_INSERTING_DATES_OR_TIMES_STEPS@la1n40en.hlp>Steps
4 Adding buttons to run macros=H_ADDING_MACRO_BUTTONS_STEPS@la1n40en.hlp>Steps
3 Change Objects and Text
4 Applying properties from another object (Fast Format)=H_APPLYING_PROPERTIES_FROM_ANOTHER_OBJECT_STEPS@la1n40en.hlp>Steps
4 Selecting objects=H_SELECTING_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Resizing objects=H_RESIZING_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Moving objects=H_MOVING_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Selecting text in text blocks=H_SELECTING_TEXT_IN_A_TEXT_BLOCK_STEPS@la1n40en.hlp>Steps
4 Cutting or copying objects or text=H_CUTTING_OR_COPYING_OBJECTS_OR_TEXT_STEPS@la1n40en.hlp>Steps
4 Changing the width of lines or borders=H_CHANGING_THE_WIDTH_OF_LINES_OR_BORDERS_STEPS@la1n40en.hlp>Steps
4 Creating partial borders=H_CREATING_PARTIAL_BORDERS_STEPS@la1n40en.hlp>Steps
4 Making objects and views transparent=H_MAKING_OBJECTS_AND_VIEWS_TRANSPARENT_STEPS@la1n40en.hlp>Steps
4 Putting objects and fields in the tab order=H_PUTTING_OBJECTS_AND_FIELDS_IN_THE_TAB_ORDER_STEPS@la1n40en.hlp>Steps
4 Changing the tab order on views=H_CHANGING_THE_TAB_ORDER_ON_VIEWS_STEPS@la1n40en.hlp>Steps
3 Work with More Than One Object at a Time
4 Grouping and ungrouping objects=H_GROUPING_AND_UNGROUPING_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Changing the order of overlapping objects=H_CHANGING_THE_ORDER_OF_OVERLAPPING_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Aligning and distributing objects=H_ALIGNING_AND_DISTRIBUTING_OBJECTS_STEPS@la1n40en.hlp>Steps
3 Edit Views
4 Naming views=H_NAMING_VIEWS_AND_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Selecting a main database for a view=H_SELECTING_A_MAIN_DATABASE_FOR_A_VIEW_STEPS@la1n40en.hlp>Steps
4 Changing the menu for a view=H_CHANGING_THE_MENU_FOR_A_VIEW_STEPS@la1n40en.hlp>Steps
4 Hiding views=H_HIDING_VIEWS_STEPS@la1n40en.hlp>Steps
4 Redisplaying hidden views=H_REDISPLAYING_HIDDEN_VIEWS_STEPS@la1n40en.hlp>Steps
4 Showing more of the view by hiding its margins=H_SHOWING_MORE_OF_THE_VIEW_BY_HIDING_ITS_MARGINS_STEPS@la1n40en.hlp>Steps
4 Changing the width of the view border=H_CHANGING_THE_WIDTH_OF_LINES_OR_BORDERS_STEPS@la1n40en.hlp>Steps
4 Creating partial borders for views=H_CREATING_PARTIAL_BORDERS_STEPS@la1n40en.hlp>Steps
4 Duplicating views=H_DUPLICATING_VIEWS_STEPS@la1n40en.hlp>Steps
4 Deleting views=H_DELETING_VIEWS_STEPS@la1n40en.hlp>Steps
4 Deleting elements of a view=H_DELETING_ELEMENTS_OF_A_VIEW_STEPS@la1n40en.hlp>Steps
4 Adding fields to a view=H_ADDING_FIELDS_TO_A_VIEW_STEPS@la1n40en.hlp>Steps
2 Preview and Print
3 Overview: Printing Approach views=H_PRINTING_APPROACH_VIEWS_OVER@la1n40en.hlp>Overview
3 Downloading data before previewing=H_DOWNLOADING_DATA_BEFORE_PREVIEWING_STEPS@la1n40en.hlp>Steps
3 Previewing views=H_PREVIEWING_VIEWS_STEPS@la1n40en.hlp>Steps
3 Printing views=H_PRINTING_VIEWS_STEPS@la1n40en.hlp>Steps
3 Formatting worksheets or crosstabs for printing=H_FORMATTING_WORKSHEETS_OR_CROSSTABS_FOR_PRINTING_STEPS@la1n40en.hlp>Steps
3 Reducing or expanding sections of reports when printing=H_PRINTING_REPORTS_STEPS@la1n40en.hlp>Steps
3 Closing up extra space between fields=H_CLOSING_EXTRA_SPACE_BETWEEN_FIELDS_STEPS@la1n40en.hlp>Steps
3 Setting objects and fields to slide when printing=H_SETTING_OBJECTS_AND_FIELDS_TO_SLIDE_WHEN_PRINTING_STEPS@la1n40en.hlp>Steps
3 Preventing objects and fields from printing=H_PREVENTING_OBJECTS_AND_FIELDS_FROM_PRINTING_STEPS@la1n40en.hlp>Steps
3 Properties of printers=H_PROPERTIES_OF_PRINTERS_REF@la1n40en.hlp>Overview
3 Specifying the printer, paper, and orientation=H_SPECIFYING_THE_PRINTER_PAPER_AND_ORIENTATION_STEPS@la1n40en.hlp>Steps
3 Printing a list of file properties=H_APPROACH_FILE_PROPERTIES_REF@la1n40en.hlp>Overview
3 Printing a list of database fields=H_PRINTING_A_LIST_OF_DATABASE_FIELDS_STEPS@la1n40en.hlp>Steps
3 Printing a diagram of join relationships=H_PRINTING_A_DIAGRAM_OF_JOIN_RELATIONSHIPS_STEPS@la1n40en.hlp>Steps
3 Printing macros=H_PRINTING_MACRO_COMMANDS_STEPS@la1n40en.hlp>Steps
2 Design Forms and Repeating Panels
3 Create Forms
4 Overview: Forms=H_FORMS_OVER@la1n40en.hlp>Overview
4 Deciding what new forms look like=H_DECIDING_WHAT_NEW_FORMS_LOOK_LIKE_REF@la1n40en.hlp>Overview
4 Adding fields to new forms=H_ADDING_FIELDS_TO_NEW_FORMS_STEPS@la1n40en.hlp>Steps
4 Removing or reordering fields while creating new views=H_REMOVING_OR_REORDERING_FIELDS_WHILE_CREATING_NEW_VIEWS_STEPS@la1n40en.hlp>Steps
4 Creating new forms that include a repeating panel=H_ADDING_A_REPEATING_PANEL_TO_NEW_FORMS_STEPS@la1n40en.hlp>Steps
4 Adding pages to forms=H_ADDING_PAGES_TO_FORMS_STEPS@la1n40en.hlp>Steps
3 Create Repeating Panels
4 Overview: Repeating panels=H_REPEATING_PANELS_OVER@la1n40en.hlp>Overview
4 Creating new forms that include a repeating panel=H_ADDING_A_REPEATING_PANEL_TO_NEW_FORMS_STEPS@la1n40en.hlp>Steps
4 Adding a repeating panel to existing forms=H_ADDING_A_REPEATING_PANEL_TO_EXISTING_FORMS_STEPS@la1n40en.hlp>Steps
4 Summarizing data for records in repeating panels=H_SUMMARIZING_DATA_FOR_RECORDS_IN_REPEATING_PANELS_STEPS@la1n40en.hlp>Steps
4 Adding fields to repeating panels=H_ADDING_FIELDS_TO_REPEATING_PANELS_STEPS@la1n40en.hlp>Steps
4 Selecting repeating panels=H_SELECTING_REPEATING_PANELS_STEPS@la1n40en.hlp>Steps
4 Setting a default sort order for a repeating panel=H_SORTING_RECORDS_IN_REPEATING_PANELS_STEPS@la1n40en.hlp>Steps
4 Naming repeating panels=H_NAMING_VIEWS_AND_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Design Repeating Panels
5 Hiding labels in repeating panels=H_HIDING_LABELS_IN_REPEATING_PANELS_STEPS@la1n40en.hlp>Steps
5 Rearranging fields in repeating panels=H_REARRANGING_FIELDS_IN_REPEATING_PANELS_STEPS@la1n40en.hlp>Steps
5 Resizing repeating panels=H_RESIZING_REPEATING_PANELS_STEPS@la1n40en.hlp>Steps
5 Alternating the color of records in a repeating panel=H_ALTERNATING_THE_COLOR_OF_RECORDS_IN_A_REPEATING_PANEL_STEPS@la1n40en.hlp>Steps
5 Changing the width of borders for repeating panels=H_CHANGING_THE_WIDTH_OF_LINES_OR_BORDERS_STEPS@la1n40en.hlp>Steps
5 Creating partial borders around repeating panels=H_CREATING_PARTIAL_BORDERS_STEPS@la1n40en.hlp>Steps
5 Creating a shadow behind repeating panels=H_CREATING_A_SHADOW_STEPS@la1n40en.hlp>Steps
2 Design Worksheets
3 Creating new worksheets=H_CREATING_NEW_WORKSHEETS_STEPS@la1n40en.hlp>Steps
3 Selecting in worksheets or crosstabs=H_SELECTING_IN_WORKSHEETS_OR_CROSSTABS_REF@la1n40en.hlp>Overview
3 Copying selections to the Clipboard=H_COPYING_SELECTIONS_TO_THE_CLIPBOARD_STEPS@la1n40en.hlp>Steps
3 Dividing worksheets and crosstabs into panes=H_DIVIDING_WORKSHEETS_AND_CROSSTABS_INTO_PANES_STEPS@la1n40en.hlp>Steps
3 Formatting worksheets or crosstabs for printing=H_FORMATTING_WORKSHEETS_OR_CROSSTABS_FOR_PRINTING_STEPS@la1n40en.hlp>Steps
3 Removing fields from worksheets or crosstabs=H_REMOVING_FIELDS_FROM_WORKSHEETS_OR_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Moving columns in worksheets or crosstabs=H_MOVING_COLUMNS_IN_WORKSHEETS_OR_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Resizing columns and rows in worksheets or crosstabs =H_RESIZING_COLUMNS_AND_ROWS_IN_WORKSHEETS_OR_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Adding formula columns to worksheets=H_ADDING_FORMULA_COLUMNS_TO_WORKSHEETS_STEPS@la1n40en.hlp>Steps
3 Adding blank columns to worksheets=H_ADDING_BLANK_COLUMNS_TO_WORKSHEETS_STEPS@la1n40en.hlp>Steps
3 Editing column header text=H_EDITING_COLUMN_HEADER_TEXT_STEPS@la1n40en.hlp>Steps
2 Design Reports
3 Overview: Reports=H_REPORTS_OVER@la1n40en.hlp>Overview
3 Overview: Report panels=H_REPORT_PANELS_OVER@la1n40en.hlp>Overview
3 Use PowerClick Reporting
4 Creating a PowerClick report with a grand total=H_CREATING_A_POWERCLICK_REPORT_WITH_A_GRAND_TOTAL_STEPS@la1n40en.hlp>Steps
4 Creating a PowerClick report with subtotals for groups=H_CREATING_A_POWERCLICK_REPORT_WITH_SUBTOTALS_FOR_GROUPS_STEPS@la1n40en.hlp>Steps
4 Grouping records in reports=H_GROUPING_RECORDS_IN_REPORTS_STEPS@la1n40en.hlp>Steps
4 Adding summaries to reports=H_ADDING_SUMMARIES_TO_REPORTS_STEPS@la1n40en.hlp>Steps
3 Create Reports
4 Deciding what new reports look like=H_DECIDING_WHAT_NEW_REPORTS_LOOK_LIKE_REF@la1n40en.hlp>Overview
4 Adding fields to new reports=H_ADDING_FIELDS_TO_NEW_REPORTS_STEPS@la1n40en.hlp>Steps
4 Grouping records in new reports=H_GROUPING_RECORDS_IN_NEW_REPORTS_STEPS@la1n40en.hlp>Steps
4 Adding repeating fields to new repeating panel reports=H_ADDING_REPEATING_FIELDS_TO_NEW_REPEATING_PANEL_REPORTS_STEPS@la1n40en.hlp>Steps
4 Adding summaries to new reports=H_ADDING_SUMMARIES_TO_NEW_REPORTS_STEPS@la1n40en.hlp>Steps
3 Summarize Data in Reports
4 Adding summaries to reports=H_ADDING_SUMMARIES_TO_REPORTS_STEPS@la1n40en.hlp>Steps
4 Summary calculations=H_SUMMARY_CALCULATIONS_REF@la1n40en.hlp>Overview
4 Choosing which records go into a summary=H_CHOOSING_WHICH_RECORDS_GO_INTO_A_SUMMARY_STEPS@la1n40en.hlp>Steps
4 Moving summaries=H_MOVING_SUMMARIES_STEPS@la1n40en.hlp>Steps
3 Revise Reports
4 Adding fields to reports=H_ADDING_FIELDS_TO_REPORTS_STEPS@la1n40en.hlp>Steps
4 Creating charts in reports=H_CREATING_CHARTS_IN_REPORTS_STEPS@la1n40en.hlp>Steps
4 Selecting, moving, and deleting report panels=H_SELECTING_MOVING_AND_DELETING_REPORT_PANELS_STEPS@la1n40en.hlp>Steps
4 Grouping records in reports=H_GROUPING_RECORDS_IN_REPORTS_STEPS@la1n40en.hlp>Steps
4 Changing the number of columns in reports=H_CHANGING_THE_NUMBER_OF_COLUMNS_IN_REPORTS_STEPS@la1n40en.hlp>Steps
4 Moving and resizing report columns=H_MOVING_AND_RESIZING_REPORT_COLUMNS_STEPS@la1n40en.hlp>Steps
4 Showing missing records in a report=H_SHOWING_ALL_GROUPS_IN_A_REPORT_STEPS@la1n40en.hlp>Steps
3 Print Reports
4 Reducing or expanding sections of reports when printing=H_PRINTING_REPORTS_STEPS@la1n40en.hlp>Steps
4 Creating title pages for reports=H_CREATING_TITLE_PAGES_FOR_REPORTS_STEPS@la1n40en.hlp>Steps
4 Adding dates, times, or page numbers to reports=H_ADDING_DATES_TIMES_OR_PAGE_NUMBERS_TO_REPORTS_STEPS@la1n40en.hlp>Steps
4 Changing the number of columns in reports=H_CHANGING_THE_NUMBER_OF_COLUMNS_IN_REPORTS_STEPS@la1n40en.hlp>Steps
4 Paginating reports=H_PAGINATING_REPORTS_STEPS@la1n40en.hlp>Steps
2 Design Form Letters
3 Overview: Form letters=H_FORM_LETTERS_OVER@la1n40en.hlp>Overview
3 Create Form Letters
4 Deciding what new form letters look like=H_DECIDING_WHAT_NEW_FORM_LETTERS_LOOK_LIKE_REF@la1n40en.hlp>Overview
4 Adding the return address to form letters=H_ADDING_THE_RETURN_ADDRESS_TO_FORM_LETTERS_STEPS@la1n40en.hlp>Steps
4 Adding the recipient address to form letters=H_ADDING_THE_RECIPIENT_ADDRESS_TO_FORM_LETTERS_STEPS@la1n40en.hlp>Steps
4 Adding the salutation to form letters=H_ADDING_THE_SALUTATION_TO_FORM_LETTERS_STEPS@la1n40en.hlp>Steps
4 Adding the close to form letters=H_ADDING_THE_CLOSE_TO_FORM_LETTERS_STEPS@la1n40en.hlp>Steps
4 Adding envelopes to form letters=H_ADDING_ENVELOPES_TO_FORM_LETTERS_STEPS@la1n40en.hlp>Steps
3 Revise Form Letters
4 Entering text in form letters=H_ENTERING_TEXT_IN_FORM_LETTERS_STEPS@la1n40en.hlp>Steps
4 Adding fields to form letters=H_ADDING_FIELDS_TO_FORM_LETTERS_STEPS@la1n40en.hlp>Steps
4 Changing the date format on form letters=H_CHANGING_THE_DATE_FORMAT_ON_FORM_LETTERS_STEPS@la1n40en.hlp>Steps
4 Moving or deleting form letter fields=H_MOVING_OR_DELETING_FORM_LETTER_FIELDS_STEPS@la1n40en.hlp>Steps
2 Design Envelopes and Mailing Labels
3 Overview: Envelopes=H_ENVELOPES_OVER@la1n40en.hlp>Overview
3 Overview: Mailing labels=H_MAILING_LABELS_OVER@la1n40en.hlp>Overview
3 Create Envelopes
4 Deciding what new envelopes look like=H_DECIDING_WHAT_NEW_ENVELOPES_LOOK_LIKE_REF@la1n40en.hlp>Overview
4 Adding the return address to envelopes=H_ADDING_THE_RETURN_ADDRESS_TO_ENVELOPES_STEPS@la1n40en.hlp>Steps
4 Adding the recipient address to envelopes=H_ADDING_THE_RECIPIENT_ADDRESS_TO_ENVELOPES_STEPS@la1n40en.hlp>Steps
4 Selecting print settings for envelopes=H_SELECTING_PRINT_SETTINGS_FOR_ENVELOPES_STEPS@la1n40en.hlp>Steps
3 Create Mailing Labels
4 Creating mailing labels=H_CREATING_MAILING_LABELS_STEPS@la1n40en.hlp>Steps
4 Creating custom mailing label types=H_CREATING_CUSTOM_MAILING_LABEL_TYPES_STEPS@la1n40en.hlp>Steps
4 Adding text to mailing labels=H_ADDING_TEXT_TO_MAILING_LABELS_STEPS@la1n40en.hlp>Steps
4 Moving or resizing mailing label fields=H_MOVING_OR_RESIZING_MAILING_LABEL_FIELDS_STEPS@la1n40en.hlp>Steps
4 Closing up extra space between fields=H_CLOSING_EXTRA_SPACE_BETWEEN_FIELDS_STEPS@la1n40en.hlp>Steps
4 Changing or deleting custom mailing label types=H_CHANGING_OR_DELETING_CUSTOM_MAILING_LABEL_TYPES_STEPS@la1n40en.hlp>Steps
2 Design Crosstabs
3 Overview: Crosstabs=H_CROSSTABS_OVER@la1n40en.hlp>Overview
3 Adding rows to new crosstabs=H_ADDING_ROWS_TO_NEW_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Adding columns to new crosstabs=H_ADDING_COLUMNS_TO_NEW_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Adding values to new crosstabs=H_ADDING_VALUES_TO_NEW_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Adding summaries to crosstabs=H_ADDING_SUMMARIES_TO_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Editing crosstab summaries=H_EDITING_CROSSTAB_SUMMARIES_STEPS@la1n40en.hlp>Steps
3 Adding or moving fields in crosstabs=H_ADDING_OR_MOVING_FIELDS_IN_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Applying found sets to crosstabs=H_APPLYING_FOUND_SETS_TO_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Adding all groups to crosstabs=H_ADDING_ALL_GROUPS_TO_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Selecting rows and columns in crosstabs=H_SELECTING_ROWS_AND_COLUMNS_IN_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Creating charts from crosstabs=H_CREATING_CHARTS_FROM_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Overview: Drill down to data=H_DRILL_DOWN_TO_DATA_OVER@la1n40en.hlp>Overview
3 Finding records that make up crosstabs (drill down to data)=H_FINDING_RECORDS_THAT_MAKE_UP_CROSSTABS_STEPS@la1n40en.hlp>Steps
3 Selecting drill-down views=H_CHOOSING_DRILLDOWN_VIEWS_STEPS@la1n40en.hlp>Steps
2 Design Charts
3 Create Charts Using the Chart Assistant
4 Overview: Chart Assistant=H_CHART_ASSISTANT_OVER@la1n40en.hlp>Overview
4 Deciding what new charts look like=H_DECIDING_WHAT_NEW_CHARTS_LOOK_LIKE_REF@la1n40en.hlp>Overview
4 Selecting a field for the x-axis=H_SELECTING_A_FIELD_FOR_THE_X_AXIS_STEPS@la1n40en.hlp>Steps
4 Selecting fields for the y-axis=H_SELECTING_FIELDS_FOR_THE_Y_AXIS_STEPS@la1n40en.hlp>Steps
4 Selecting a field for the series (chart legend)=H_SELECTING_A_FIELD_FOR_THE_SERIES_STEPS@la1n40en.hlp>Steps
4 Creating pie charts=H_CREATING_PIE_CHARTS_STEPS@la1n40en.hlp>Steps
3 Revise Charts
4 Drill-down to data for charts=H_DRILL_DOWN_TO_DATA_FOR_CHARTS_STEPS@la1n40en.hlp>Steps
4 Charting a different data set=H_CHARTING_A_DIFFERENT_DATA_SET_STEPS@la1n40en.hlp>Steps
3 Create Charts in Reports and Crosstabs
4 Creating charts in reports=H_CREATING_CHARTS_IN_REPORTS_STEPS@la1n40en.hlp>Steps
4 Creating charts from crosstabs=H_CREATING_CHARTS_FROM_CROSSTABS_STEPS@la1n40en.hlp>Steps
:include LC1N20EN.CNT
2 Enter and Edit Data
3 Add, Delete, and Hide Records
4 Adding new records=H_ADDING_NEW_RECORDS_STEPS@la1n40en.hlp>Steps
4 Duplicating records=H_DUPLICATING_RECORDS_STEPS@la1n40en.hlp>Steps
4 Deleting specific records=H_DELETING_SPECIFIC_RECORDS_STEPS@la1n40en.hlp>Steps
4 Deleting a found set of records=H_DELETING_A_FOUND_SET_OF_RECORDS_STEPS@la1n40en.hlp>Steps
4 Deleting all records=H_DELETING_ALL_RECORDS_STEPS@la1n40en.hlp>Steps
4 Hiding records=H_HIDING_RECORDS_STEPS@la1n40en.hlp>Steps
4 Showing hidden records=H_SHOWING_HIDDEN_RECORDS_STEPS@la1n40en.hlp>Steps
3 Enter Data in Fields
4 Selecting fields=H_SELECTING_FIELDS_STEPS@la1n40en.hlp>Steps
4 Entering text in text or memo fields=H_ENTERING_TEXT_IN_TEXT_OR_MEMO_FIELDS_STEPS@la1n40en.hlp>Steps
4 Entering values in numeric fields=H_ENTERING_VALUES_IN_NUMERIC_FIELDS_STEPS@la1n40en.hlp>Steps
4 Entering values in Boolean fields=H_ENTERING_VALUES_IN_BOOLEAN_FIELDS_STEPS@la1n40en.hlp>Steps
4 Entering dates in date fields=H_ENTERING_DATES_IN_DATE_FIELDS_STEPS@la1n40en.hlp>Steps
4 Entering times in time fields=H_ENTERING_TIMES_IN_TIME_FIELDS_STEPS@la1n40en.hlp>Steps
4 Duplicating a value from the last record modified=H_DUPLICATING_VALUES_FROM_THE_LAST_RECORD_MODIFIED_STEPS@la1n40en.hlp>Steps
4 Selecting from a drop-down box=H_SELECTING_FROM_A_DROPDOWN_BOX_STEPS@la1n40en.hlp>Steps
4 Selecting radio buttons or check boxes=H_SELECTING_RADIO_BUTTONS_OR_CHECK_BOXES_STEPS@la1n40en.hlp>Steps
4 Entering the same data into many records=H_ENTERING_THE_SAME_DATA_INTO_MANY_RECORDS_STEPS@la1n40en.hlp>Steps
4 Pasting pictures in fields=H_PASTING_PICTURES_IN_FIELDS_STEPS@la1n40en.hlp>Steps
4 Drawing in PicturePlus fields=H_DRAWING_IN_PICTUREPLUS_FIELDS_STEPS@la1n40en.hlp>Steps
3 Move to Another Record
4 Moving through records one record at a time=H_MOVING_ONE_RECORD_AT_A_TIME_STEPS@la1n40en.hlp>Steps
4 Moving to the first or last record=H_MOVING_TO_THE_FIRST_OR_LAST_RECORD_STEPS@la1n40en.hlp>Steps
4 Moving to a specific record=H_MOVING_TO_A_SPECIFIC_RECORD_STEPS@la1n40en.hlp>Steps
3 Check Spelling
4 Checking spelling=H_RUNNING_THE_SPELLING_CHECKER_STEPS@la1n40en.hlp>Steps
4 Editing the user dictionary=H_EDITING_THE_USER_DICTIONARY_STEPS@la1n40en.hlp>Steps
4 Changing to another main dictionary=H_CHANGING_TO_ANOTHER_MAIN_DICTIONARY_STEPS@la1n40en.hlp>Steps
4 Setting options for checking spelling=H_SETTING_OPTIONS_FOR_CHECKING_SPELLING_STEPS@la1n40en.hlp>Steps
3 Find and Replace Text
4 Finding text=H_FINDING_TEXT_STEPS@la1n40en.hlp>Steps
4 Replacing text=H_REPLACING_TEXT_STEPS@la1n40en.hlp>Steps
2 Find Records
3 Overview: The found set=H_THE_FOUND_SET_OVER@la1n40en.hlp>Overview
3 Showing all records=H_SHOWING_ALL_RECORDS_STEPS@la1n40en.hlp>Steps
3 Find Records Using the Find Assistant
4 Overview: Finding records with the Find Assistant=H_FINDING_RECORDS_WITH_THE_FIND_ASSISTANT_OVER@la1n40en.hlp>Overview
4 Selecting a find type with the Find Assistant=H_SELECTING_A_FIND_TYPE_WITH_THE_FIND_ASSISTANT_REF@la1n40en.hlp>Overview
4 Creating a find condition with the Find Assistant=H_CREATING_A_FIND_CONDITION_WITH_THE_FIND_ASSISTANT_STEPS@la1n40en.hlp>Steps
4 Finding duplicate records with the Find Assistant=H_FINDING_DUPLICATE_RECORDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n40en.hlp>Steps
4 Finding distinct or unique records with the Find Assistant=H_FINDING_DISTINCT_OR_UNIQUE_RECORDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n40en.hlp>Steps
4 Finding the top or lowest values with the Find Assistant=H_FINDING_THE_TOP_OR_LOWEST_VALUES_WITH_THE_FIND_ASSISTANT_STEPS@la1n40en.hlp>Steps
4 Sorting fields with the Find Assistant=H_SORTING_FIELDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n40en.hlp>Steps
3 Find Records Using Query by Box
4 Finding records using Query by Box=H_FINDING_RECORDS_USING_QUERY_BY_BOX_STEPS@la1n40en.hlp>Steps
4 Overview: Defining find conditions graphically in Query by Box=H_DEFINING_FIND_CONDITIONS_GRAPHICALLY_IN_QUERY_BY_BOX_OVER@la1n40en.hlp>Overview
4 Overview: Multiple find conditions in Query by Box=H_MULTIPLE_FIND_CONDITIONS_IN_QUERY_BY_BOX_OVER@la1n40en.hlp>Overview
3 Find Records Using a Blank View
4 Creating find requests=H_CREATING_FIND_REQUESTS_STEPS@la1n40en.hlp>Steps
4 Finding records that satisfy multiple conditions (AND)=H_FINDING_RECORDS_THAT_SATISFY_MULTIPLE_CONDITIONS_(AND)_STEPS@la1n40en.hlp>Steps
4 Finding records that satisfy at least one of several conditions (OR)=H_FIND_RECORDS_TO_SATISFY_ONE_OF_SEVERAL_CONDITIONS_(OR)_STEPS@la1n40en.hlp>Steps
4 Finding records with OR conditions in more than one field=H_FINDING_RECORDS_WITH_OR_CONDITIONS_IN_MORE_THAN_ONE_FIELD_STEPS@la1n40en.hlp>Steps
4 Finding text with wildcards=H_FINDING_TEXT_WITH_WILDCARDS_STEPS@la1n40en.hlp>Steps
4 Finding case-sensitive text=H_FINDING_CASESENSITIVE_TEXT_STEPS@la1n40en.hlp>Steps
4 Finding a word that sounds like another=H_FINDING_A_WORD_THAT_SOUNDS_LIKE_ANOTHER_STEPS@la1n40en.hlp>Steps
4 Finding numbers, dates, and times=H_FINDING_NUMBERS_DATES_AND_TIMES_STEPS@la1n40en.hlp>Steps
4 Finding values in a range=H_FINDING_VALUES_IN_A_RANGE_STEPS@la1n40en.hlp>Steps
4 Finding today's date=H_FINDING_TODAYS_DATE_STEPS@la1n40en.hlp>Steps
4 Finding radio button and check box settings=H_FINDING_RADIO_BUTTON_AND_CHECK_BOX_SETTINGS_STEPS@la1n40en.hlp>Steps
4 Finding blank or nonblank fields=H_FINDING_BLANK_OR_NONBLANK_FIELDS_STEPS@la1n40en.hlp>Steps
4 Using If statements to find data=H_USING_IF_STATEMENTS_TO_FIND_DATA_STEPS@la1n40en.hlp>Steps
4 Repeating finds=H_REPEATING_FINDS_STEPS@la1n40en.hlp>Steps
3 Create Named Finds
4 Naming finds with the Find Assistant=H_NAMING_FINDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n40en.hlp>Steps
4 Naming and reviewing finds with the Find Assistant=H_NAMING_AND_REVIEWING_FINDS_WITH_THE_FIND_ASSISTANT_REF@la1n40en.hlp>Overview
4 Naming finds based on find requests=H_NAMING_FINDS_BASED_ON_FIND_REQUESTS_STEPS@la1n40en.hlp>Steps
4 Editing named finds=H_EDITING_NAMED_FINDS_STEPS@la1n40en.hlp>Steps
4 Copying named finds=H_COPYING_NAMED_FINDS_STEPS@la1n40en.hlp>Steps
4 Deleting named finds=H_DELETING_NAMED_FINDS_STEPS@la1n40en.hlp>Steps
4 Running named finds=H_RUNNING_NAMED_FINDS_STEPS@la1n40en.hlp>Steps
3 Create Query Files
4 Creating query files in Approach=H_CREATING_QUERY_FILES_IN_APPROACH_STEPS@la1n40en.hlp>Steps
4 Opening query files in Approach=H_OPENING_QUERY_FILES_IN_APPROACH_STEPS@la1n40en.hlp>Steps
4 Saving or exporting data from a query=H_SAVING_OR_EXPORTING_DATA_FROM_A_QUERY_STEPS@la1n40en.hlp>Steps
3 Create an SQL SELECT Statement with the SQL Assistant
4 Overview: Connecting to an SQL or ODBC data source=H_CONNECTING_TO_AN_SQL_OR_ODBC_DATA_SOURCE_OVER@la1n40en.hlp>Overview
4 Selecting tables for an SQL SELECT statement=H_SELECTING_TABLES_IN_THE_TABLES_TAB_STEPS@la1n40en.hlp>Steps
4 Creating joins for an SQL SELECT statement=H_CREATING_JOINS_IN_THE_JOIN_TAB_STEPS@la1n40en.hlp>Steps
4 Creating find conditions for an SQL SELECT statement=H_CREATING_FIND_CONDITIONS_IN_THE_CONDITION_TAB_STEPS@la1n40en.hlp>Steps
4 Selecting fields for an SQL SELECT statement=H_SELECTING_FIELDS_IN_THE_FIELDS_TAB_STEPS@la1n40en.hlp>Steps
4 Sorting fields for an SQL SELECT statement=H_SORTING_FIELDS_IN_THE_SORT_TAB_STEPS@la1n40en.hlp>Steps
4 Editing SQL statements=H_EDITING_SQL_STATEMENTS_IN_THE_SQL_TAB_STEPS@la1n40en.hlp>Steps
2 Sort Records
3 Specifying a sort order=H_SPECIFYING_A_SORT_ORDER_STEPS@la1n40en.hlp>Steps
3 Sorting records by a field in a view (Ascending)=H_SORTING_RECORDS_BY_A_FIELD_IN_A_VIEW_ASCENDING_STEPS@la1n40en.hlp>Steps
3 Sorting records by a field in a view (Descending)=H_SORTING_RECORDS_BY_A_FIELD_IN_A_VIEW_DESCENDING_STEPS@la1n40en.hlp>Steps
3 Setting a default sort order for looking at records in Browse=H_SETTING_A_DEFAULT_SORT_ORDER_FOR_RECORDS_IN_BROWSE_STEPS@la1n40en.hlp>Steps
3 Setting a default sort order for a repeating panel=H_SORTING_RECORDS_IN_REPEATING_PANELS_STEPS@la1n40en.hlp>Steps
2 Share Work Within Groups Using TeamMail
3 Sending e-mail messages from inside Approach=H_SENDING_EMAIL_MESSAGES_FROM_INSIDE_APPROACH_STEPS@la1n40en.hlp>Steps
3 Sending e-mail messages with attachments from inside Approach=H_SENDING_EMAIL_MESSAGES_WITH_ATTACHMENTS_FROM_INSIDE_APPROACH_STEPS@la1n40en.hlp>Steps
:include TM1N10EN.CNT
2 Share Data with Other Applications
3 Import Data
4 Importing data into databases=H_IMPORTING_DATA_INTO_DATABASES_STEPS@la1n40en.hlp>Steps
4 Opening databases created in other applications=H_OPENING_DATABASES_CREATED_IN_OTHER_APPLICATIONS_STEPS@la1n40en.hlp>Steps
4 Creating databases from spreadsheets=H_CREATING_DATABASES_FROM_SPREADSHEETS_STEPS@la1n40en.hlp>Steps
4 Creating databases from delimited text files=H_CREATING_DATABASES_FROM_DELIMITED_TEXT_FILES_STEPS@la1n40en.hlp>Steps
4 Creating databases from fixed-length text files=H_CREATING_DATABASES_FROM_FIXEDLENGTH_TEXT_FILES_STEPS@la1n40en.hlp>Steps
4 Importing Approach files=H_IMPORTING_APPROACH_FILES_STEPS@la1n40en.hlp>Steps
4 Mapping fields=H_MAPPING_FIELDS_REF@la1n40en.hlp>Overview
4 Pasting pictures in fields=H_PASTING_PICTURES_IN_FIELDS_STEPS@la1n40en.hlp>Steps
3 Export Data
4 Exporting data from Approach=H_EXPORTING_DATA_FROM_APPROACH_STEPS@la1n40en.hlp>Steps
4 Copying PicturePlus pictures to a file=H_COPYING_PICTUREPLUS_PICTURES_TO_A_FILE_STEPS@la1n40en.hlp>Steps
3 Link and Embed Objects (OLE)
4 Overview: Communicating between applications using OLE=H_COMMUNICATING_BETWEEN_APPLICATIONS_USING_OLE_OVER@la1n40en.hlp>Overview
4 Overview: OLE links=H_OLE_LINKS_OVER@la1n40en.hlp>Overview
4 Overview: OLE embedded objects=H_OLE_EMBEDDED_OBJECTS_OVER@la1n40en.hlp>Overview
4 Overview: Embedding an Approach object in another application=H_EMBEDDING_AN_APPROACH_OBJECT_IN_ANOTHER_APPLICATION_OVER@la1n40en.hlp>Overview
4 Creating Approach OLE objects in Approach (Copy View)=H_CREATING_APPROACH_OLE_OBJECTS_IN_APPROACH_STEPS@la1n40en.hlp>Steps
4 Creating Approach OLE objects from other applications=H_CREATING_APPROACH_OLE_OBJECTS_FROM_OTHER_APPLICATIONS_STEPS@la1n40en.hlp>Steps
4 Creating linked objects from files=H_CREATING_OLE_OBJECTS_FROM_FILES_STEPS@la1n40en.hlp>Steps
4 Inserting linked objects from the Clipboard=H_INSERTING_LINKED_OBJECTS_FROM_THE_CLIPBOARD_STEPS@la1n40en.hlp>Steps
4 Editing linked objects=H_EDITING_LINKED_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Modifying links=H_MODIFYING_LINKS_BETWEEN_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Embedding OLE objects based on existing files=H_EMBEDDING_EXISTING_OLE_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Embedding new OLE objects=H_EMBEDDING_NEW_OLE_OBJECTS_STEPS@la1n40en.hlp>Steps
4 Editing embedded objects=H_EDITING_EMBEDDED_OBJECTS_STEPS@la1n40en.hlp>Steps
3 Work with Custom Controls (OCX)
4 Overview: OLE Custom Controls=H_OLE_CUSTOM_CONTROLS_OVER@la1n40en.hlp>Overview
4 Registering custom controls=H_REGISTERING_CUSTOM_CONTROLS_STEPS@la1n40en.hlp>Steps
4 Inserting custom controls in views=H_INSERTING_CUSTOM_CONTROLS_IN_VIEWS_STEPS@la1n40en.hlp>Steps
4 Changing properties of custom controls=H_CHANGING_PROPERTIES_OF_CUSTOM_CONTROLS_STEPS@la1n40en.hlp>Steps
4 Adding custom controls to the Tools palette=H_ADDING_CUSTOM_CONTROLS_TO_THE_TOOLS_PALETTE_STEPS@la1n40en.hlp>Steps
2 Share Data on a Network
3 Setting file-sharing options for dBASE files=H_SETTING_FILESHARING_OPTIONS_FOR_DBASE_FILES_STEPS@la1n40en.hlp>Steps
3 Specifying locking protocols for shared dBASE files=H_SPECIFYING_LOCKING_PROTOCOLS_FOR_SHARED_DBASE_FILES_STEPS@la1n40en.hlp>Steps
3 Setting file-sharing options for Paradox files=H_SETTING_FILESHARING_OPTIONS_FOR_PARADOX_FILES_STEPS@la1n40en.hlp>Steps
3 Changing the status to single-user=H_CHANGING_THE_STATUS_TO_SINGLE_USER_STEPS@la1n40en.hlp>Steps
3 Entering passwords=H_ENTERING_PASSWORDS_STEPS@la1n40en.hlp>Steps
3 Refreshing the data network onscreen=H_REFRESHING_THE_DATA_NETWORK_ONSCREEN_STEPS@la1n40en.hlp>Steps
3 Saving changes to shared records=H_SAVING_CHANGES_TO_SHARED_RECORDS_STEPS@la1n40en.hlp>Steps
2 Customize Approach
3 Set Approach Preferences
4 Setting display preferences for the Approach window=H_SETTING_DISPLAY_PREFERENCES_FOR_THE_APPROACH_WINDOW_REF@la1n40en.hlp>Overview
4 Showing summaries in reports=H_SETTING_DISPLAY_PREFERENCES_FOR_THE_APPROACH_WINDOW_REF@la1n40en.hlp>Overview
4 Setting preferences for the Design environment=H_SETTING_PREFERENCES_FOR_THE_DESIGN_ENVIRONMENT_REF@la1n40en.hlp>Overview
4 Adding custom controls to the Tools palette=H_ADDING_CUSTOM_CONTROLS_TO_THE_TOOLS_PALETTE_STEPS@la1n40en.hlp>Steps
4 Setting a default sort order for looking at records in Browse=H_SETTING_A_DEFAULT_SORT_ORDER_FOR_RECORDS_IN_BROWSE_STEPS@la1n40en.hlp>Steps
4 Defining passwords for a database=H_DEFINING_PASSWORDS_FOR_A_DATABASE_STEPS@la1n40en.hlp>Steps
4 Identifying default directories=H_IDENTIFYING_DEFAULT_DIRECTORIES_STEPS@la1n40en.hlp>Steps
4 Displaying the contents of drop-down boxes automatically=H_DISPLAYING_THE_CONTENTS_OF_DROPDOWN_BOXES_AUTOMATICALLY_STEPS@la1n40en.hlp>Steps
4 Moving between fields using ENTER=H_MOVING_BETWEEN_FIELDS_USING_ENTER_STEPS@la1n40en.hlp>Steps
4 Showing the Add Field dialog box after creating new fields=H_SHOWING_THE_ADD_FIELD_DIALOG_BOX_AFTER_CREATING_NEW_FIELDS_STEPS@la1n40en.hlp>Steps
4 Showing the Cancel Macro dialog box while running macros=H_SHOWING_THE_CANCEL_MACRO_DIALOG_BOX_WHILE_RUNNING_MACROS_STEPS@la1n40en.hlp>Steps
4 Making calculated fields available for joins=H_MAKING_CALCULATED_FIELDS_AVAILABLE_FOR_JOINS_STEPS@la1n40en.hlp>Steps
4 Entering data using optimistic record locking=H_ENTERING_DATA_USING_OPTIMISTIC_RECORD_LOCKING_STEPS@la1n40en.hlp>Steps
4 Downloading data before previewing=H_DOWNLOADING_DATA_BEFORE_PREVIEWING_STEPS@la1n40en.hlp>Steps
4 Setting dialing preferences=H_SETTING_DIALING_PREFERENCES_REF@la1n40en.hlp>Overview
4 Setting preferences for database files=H_SETTING_PREFERENCES_FOR_DATABASE_FILES_REF@la1n40en.hlp>Overview
4 Maintaining external indexes for dBASE or FoxPro databases=H_MAINTAINING_EXTERNAL_INDEXES_FOR_DBASE_OR_FOXPRO_DATABASES_STEPS@la1n40en.hlp>Steps
4 Closing external indexes for dBASE or FoxPro databases=H_CLOSING_EXTERNAL_INDEXES_FOR_DBASE_OR_FOXPRO_DATABASES_STEPS@la1n40en.hlp>Steps
4 Creating secondary indexes for Paradox databases=H_CREATING_SECONDARY_INDEXES_FOR_PARADOX_DATABASES_STEPS@la1n40en.hlp>Steps
4 Deleting secondary indexes for Paradox databases=H_DELETING_SECONDARY_INDEXES_FOR_PARADOX_DATABASES_STEPS@la1n40en.hlp>Steps
3 Customize Menus
4 Custom menus=H_CUSTOM_MENUS_REF@la1n40en.hlp>Overview
4 Creating custom menus=H_CREATING_CUSTOM_MENUS_STEPS@la1n40en.hlp>Steps
4 Creating a custom menu by copying one that exists=H_CREATING_A_CUSTOM_MENU_BY_COPYING_ONE_THAT_EXISTS_STEPS@la1n40en.hlp>Steps
4 Editing custom menus=H_EDITING_CUSTOM_MENUS_STEPS@la1n40en.hlp>Steps
4 Moving and deleting commands on custom menus=H_MOVING_AND_DELETING_CUSTOMMENU_COMMANDS_STEPS@la1n40en.hlp>Steps
4 Deleting custom menus=H_DELETING_CUSTOM_MENUS_STEPS@la1n40en.hlp>Steps
1 Demo Catalog
2 Using demos=H_USING_DEMOS_REF@la1n40en.hlp>Overview
1 Tools for Getting Your Work Done
2 Installing additional language versions of Approach=H_INSTALLING_ADDITIONAL_LANGUAGE_VERSIONS_OF_APPROACH_OVER@la1n40en.hlp>Overview
2 Keyboard Information
3 Moving between fields=H_MOVING_BETWEEN_FIELDS_REF@la1n40en.hlp>Overview
3 Keyboard shortcuts=H_KEYBOARD_SHORTCUTS_REF@la1n40en.hlp>Overview
3 Moving within fields=H_MOVING_WITHIN_FIELDS_REF@la1n40en.hlp>Overview
3 Selecting within fields=H_SELECTING_WITHIN_FIELDS_REF@la1n40en.hlp>Overview
2 Menus
3 Shortcut menus=H_SHORTCUT_MENUS_STEPS@la1n40en.hlp>Steps
3 File menu=H_FILE_MENU_REF@la1n40en.hlp>Overview
3 Edit menu=H_EDIT_MENU_REF@la1n40en.hlp>Overview
3 View menu=H_VIEW_MENU_REF@la1n40en.hlp>Overview
3 Create menu=H_CREATE_MENU_REF@la1n40en.hlp>Overview
3 Window menu=H_WINDOW_MENU_REF@la1n40en.hlp>Overview
3 Help menu=H_HELP_MENU_REF@la1n40en.hlp>Overview
3 Context Menus
4 Browse menu=H_BROWSE_MENU_REF@la1n40en.hlp>Overview
4 Chart menu=H_CHART_MENU_REF@la1n40en.hlp>Overview
4 Column menu=H_COLUMN_MENU_REF@la1n40en.hlp>Overview
4 Crosstab menu=H_CROSSTAB_MENU_REF@la1n40en.hlp>Overview
4 Envelope menu=H_ENVELOPE_MENU_REF@la1n40en.hlp>Overview
4 Form menu=H_FORM_MENU_REF@la1n40en.hlp>Overview
4 Form Letter menu=H_FORM_LETTER_MENU_REF@la1n40en.hlp>Overview
4 Mailing Label menu=H_MAILING_LABEL_MENU_REF@la1n40en.hlp>Overview
4 Object menu=H_OBJECT_MENU_REF@la1n40en.hlp>Overview
4 Report menu=H_REPORT_MENU_REF@la1n40en.hlp>Overview
4 Text menu=H_TEXT_MENU_REF@la1n40en.hlp>Overview
4 Worksheet menu=H_WORKSHEET_MENU_REF@la1n40en.hlp>Overview
2 SmartIcons
3 Overview: SmartIcons=H_SMARTICONS_OVER@la1n40en.hlp>Overview
3 Overview: Using SmartIcons=H_USING_SMARTICONS_OVER@la1n40en.hlp>Overview
3 Using an icon=H_USING_AN_ICON_STEPS@la1n40en.hlp>Steps
3 Modifying a Set of SmartIcons
4 Adding an icon to a set of SmartIcons=H_ADDING_AN_ICON_TO_A_SET_OF_SMARTICONS_STEPS@la1n40en.hlp>Steps
4 Removing an icon from a set of SmartIcons=H_REMOVING_AN_ICON_FROM_A_SET_OF_SMARTICONS_STEPS@la1n40en.hlp>Steps
4 Sizing icons in a SmartIcons set=H_SIZING_ICONS_IN_A_SMARTICONS_SET_STEPS@la1n40en.hlp>Steps
4 Spacing between SmartIcons in a set=H_SPACING_BETWEEN_SMARTICONS_IN_A_SET_STEPS@la1n40en.hlp>Steps
4 Creating a new SmartIcons set=H_CREATING_A_NEW_SMARTICONS_SET_STEPS@la1n40en.hlp>Steps
4 Deleting a SmartIcons set=H_DELETING_A_SMARTICONS_SET_STEPS@la1n40en.hlp>Steps
4 Displaying or hiding SmartIcons bubble help=H_DISPLAYING_OR_HIDING_SMARTICONS_BUBBLE_HELP_STEPS@la1n40en.hlp>Steps
3 SmartIcons in the Work Area
4 Overview: Placing SmartIcons in the work area=H_PLACING_SMARTICONS_ON_THE_WORKSPACE_OVER@la1n40en.hlp>Overview
4 Placing a set of SmartIcons using the mouse=H_PLACING_A_SET_OF_SMARTICONS_USING_THE_MOUSE_STEPS@la1n40en.hlp>Steps
4 Selecting and displaying a specific icon set=H_SELECTING_AND_DISPLAYING_A_SPECIFIC_ICON_SET_STEPS@la1n40en.hlp>Steps
4 Displaying or hiding SmartIcons=H_DISPLAYING_OR_HIDING_SMARTICONS_STEPS@la1n40en.hlp>Steps
4 Hiding SmartIcons using the bar button=H_HIDING_SMARTICONS_USING_THE_BAR_BUTTON_STEPS@la1n40en.hlp>Steps
4 Moving an icon using the mouse=H_MOVING_AN_ICON_USING_THE_MOUSE_STEPS@la1n40en.hlp>Steps
4 Selecting a SmartIcons set using the bar button=H_SELECTING_A_SMARTICONS_SET_USING_THE_BAR_BUTTON_STEPS@la1n40en.hlp>Steps
4 Setting location preferences for context SmartIcons=H_SETTING_LOCATION_PREFERENCES_FOR_CONTEXT_SMARTICONS_STEPS@la1n40en.hlp>Steps
2 Functions
3 List of functions=H_FUNCTIONS_ALPHA_REF@la1n40en.hlp>Overview
3 Overview: Functions=H_FUNCTIONS_OVER@la1n40en.hlp>Overview
3 Overview: Formulas=H_FORMULAS_OVER@la1n40en.hlp>Overview
3 Overview: Field references, constants, and operators=H_OPERATORS_OVER@la1n40en.hlp>Overview
3 Date and time constants=H_DATE_AND_TIME_CONSTANTS_REF@la1n40en.hlp>Overview
2 Macros
3 List of macro commands=H_MACRO_COMMANDS_ALPHA_REF@la1n40en.hlp>Overview
3 Overview: Macros=H_MACROS_OVER@la1n40en.hlp>Overview
3 Define Macro dialog box=H_DEFINE_MACRO_DIALOG_BOX_REF>Overview
3 Printing macros=H_PRINTING_MACRO_COMMANDS_STEPS>Steps
3 Running script functions with a macro=H_RUNNING_SCRIPT_FUNCTIONS_WITH_A_MACRO_STEPS>Steps
3 Write Macros
4 Creating new macros=H_CREATING_NEW_MACROS_STEPS@la1n40en.hlp>Steps
4 Creating macros based on existing macros=H_CREATING_MACROS_BASED_ON_EXISTING_MACROS_STEPS>Steps
4 Editing macros=H_EDITING_MACROS_STEPS@la1n40en.hlp>Steps
4 Deleting macros=H_DELETING_MACROS_STEPS@la1n40en.hlp>Steps
4 Attaching macros=H_ATTACHING_MACROS_STEPS@la1n40en.hlp>Steps
4 Adding macros to the Run Macro menu=H_ADDING_MACROS_TO_THE_RUN_MACRO_MENU_STEPS@la1n40en.hlp>Steps
3 Use Macros: Suggestions for Use
4 Creating looping macros=H_CREATING_LOOPING_MACROS_STEPS@la1n40en.hlp>Steps
4 Defining a conditional macro=H_DEFINING_A_CONDITIONAL_MACRO_STEPS@la1n40en.hlp>Steps
4 Running macros from buttons in a message box=H_RUNNING_MACROS_FROM_BUTTONS_IN_A_MESSAGE_BOX_STEPS>Steps
4 Setting a value in a field with a macro=H_SETTING_A_VALUE_IN_A_FIELD_WITH_A_MACRO_STEPS@la1n40en.hlp>Steps
4 Switching to another view with a macro=H_SWITCHING_TO_ANOTHER_VIEW_WITH_A_MACRO_STEPS@la1n40en.hlp>Steps
2 File Types
3 File extensions in Approach=H_FILE_EXTENSIONS_IN_APPROACH_REF@la1n40en.hlp>Overview
3 dBASE files in Approach=H_DBASE_FILES_IN_APPROACH_REF@la1n40en.hlp>Overview
3 FoxPro files in Approach=H_FOXPRO_FILES_IN_APPROACH_REF@la1n40en.hlp>Overview
3 IBM DB2 tables in Approach=H_IBM_DB2_TABLES_IN_APPROACH_REF@la1n40en.hlp>Overview
3 ODBC data sources in Approach=H_ODBC_DATA_SOURCES_IN_APPROACH_REF@la1n40en.hlp>Overview
3 Oracle SQL tables in Approach=H_ORACLE_SQL_TABLES_IN_APPROACH_REF@la1n40en.hlp>Overview
3 Paradox files in Approach=H_PARADOX_FILES_IN_APPROACH_REF@la1n40en.hlp>Overview
3 Query files in Approach=H_QUERY_FILES_IN_APPROACH_REF@la1n40en.hlp>Overview
3 SQL Server tables in Approach=H_SQL_SERVER_TABLES_IN_APPROACH_REF@la1n40en.hlp>Overview
3 Troubleshooting Sybase SQL Server=H_TROUBLESHOOTING_SYBASE_SQL_SERVER_REF@la1n40en.hlp>Overview
1 Did You Know. . .
2 Browse is for data, Design is for style=H_BROWSE_IS_FOR_DATA_DESIGN_IS_FOR_STYLE_REF@la1n40en.hlp>Overview
2 Approach saves data automatically=H_APPROACH_SAVES_DATA_AUTOMATICALLY_REF@la1n40en.hlp>Overview
2 A sort is not a find=H_A_SORT_IS_NOT_A_FIND_REF@la1n40en.hlp>Overview
2 Select Print Preview to see report summaries=H_SELECT_PRINT_PREVIEW_TO_SEE_REPORT_SUMMARIES_REF@la1n40en.hlp>Overview
1 LotusScript
:include LSEN30EN.CNT
:include LSLN30EN.CNT
:include LASN40EN.CNT
:include FL2C10EN.CNT
:include WP0N70EN.CNT
1 What's New for Upgraders
2 What's new in Approach 96=H_WHATS_NEW_IN_APPROACH_96_REF@la1n40en.hlp>Overview
2 Installing additional language versions of Approach=H_INSTALLING_ADDITIONAL_LANGUAGE_VERSIONS_OF_APPROACH_OVER@la1n40en.hlp>Overview
1 Using Applications Together
2 Share Work Within Groups Using TeamMail
3 Sending e-mail messages from inside Approach=H_SENDING_EMAIL_MESSAGES_FROM_INSIDE_APPROACH_STEPS@la1n40en.hlp>Steps
3 Sending e-mail messages with attachments from inside Approach=H_SENDING_EMAIL_MESSAGES_WITH_ATTACHMENTS_FROM_INSIDE_APPROACH_STEPS@la1n40en.hlp>Steps
:include TM1N10EN.CNT
2 Working Together with Lotus Notes
3 Opening views or forms from a local Notes database=H_OPENING_LOTUS_NOTES_VIEWS_OR_FORMS_FROM_A_LOCAL_NOTES_DATABASE_STEPS@la1n40en.hlp>Steps
3 Opening views or forms from a Notes database on a server=H_OPENING_LOTUS_NOTES_VIEWS_OR_FORMS_FROM_A_NOTES_DATABASE_ON_A_SERVER_STEPS@la1n40en.hlp>Steps
3 Replicating a Notes database=H_REPLICATING_A_NOTES_DATABASE_STEPS@la1n40en.hlp>Steps
3 Replicating Notes databases with a server=H_REPLICATING_NOTES_DATABASES_WITH_A_SERVER_STEPS@la1n40en.hlp>Steps
3 Notes/FX
4 Enabling variable fields for Notes/FX=H_ENABLING_VARIABLE_FIELDS_FOR_NOTES_FX_STEPS@la1n40en.hlp>Steps
4 Overview: Exchanging data between Approach and Notes=H_EXCHANGING_DATA_BETWEEN_APPROACH_AND_NOTES_OVER@la1n40en.hlp>Overview
4 Overview: Setting up Notes/FX=H_SETTING_UP_NOTES_FIELD_EXCHANGE_OVER@la1n40en.hlp>Overview
4 Setting up fields for two-way exchange with Notes=H_SETTING_UP_FIELDS_FOR_TWOWAY_EXCHANGE_WITH_NOTES_STEPS@la1n40en.hlp>Steps
4 Adding Notes/FX fields to a Notes form=H_ADDING_NOTESFX_FIELDS_TO_A_NOTES_FORM_STEPS@la1n40en.hlp>Steps
4 Embedding an Approach object in a Notes document=H_EMBEDDING_AN_APPROACH_OBJECT_IN_AN_EXISTING_NOTES_FORM_STEPS@la1n40en.hlp>Steps
4 Embedding an Approach object in a Notes form=H_EMBEDDING_AN_APPROACH_OBJECT_IN_A_NOTES_FORM_DESIGN_STEPS@la1n40en.hlp>Steps
4 Creating a new Notes document=H_CREATING_A_NEW_NOTES_DOCUMENT_STEPS@la1n40en.hlp>Steps
4 Updating fields in a Notes document from Approach=H_UPDATING_FIELDS_IN_A_NOTES_DOCUMENT_FROM_APPROACH_STEPS@la1n40en.hlp>Steps
4 Updating information in Approach from a Notes document=H_UPDATING_INFORMATION_IN_APPROACH_FROM_A_NOTES_DOCUMENT_STEPS@la1n40en.hlp>Steps
2 Working Together with Lotus 1-2-3
3 Opening named ranges from Lotus 1-2-3 spreadsheets=H_OPENING_NAMED_RANGES_FROM_LOTUS_123_SPREADSHEETS_STEPS@la1n40en.hlp>Steps
3 Creating Approach views in Lotus 1-2-3=H_CREATING_APPROACH_VIEWS_IN_LOTUS_123_STEPS@la1n40en.hlp>Steps
3 Creating databases from spreadsheets=H_CREATING_DATABASES_FROM_SPREADSHEETS_STEPS@la1n40en.hlp>Steps
1 Troubleshooting
2 Contacting customer support=H_LOTUS_CUSTOMER_SUPPORT_CONTENTS_OVER@cs1n40en.hlp>Big
2 Messages
3 Common messages=H_COMMON_MESSAGES_IN_APPROACH_REF@la1n40en.hlp>Overview
2 Did You Know. . .
3 Browse is for data, Design is for style=H_BROWSE_IS_FOR_DATA_DESIGN_IS_FOR_STYLE_REF@la1n40en.hlp>Overview
3 Approach saves data automatically=H_APPROACH_SAVES_DATA_AUTOMATICALLY_REF@la1n40en.hlp>Overview
3 A sort is not a find=H_A_SORT_IS_NOT_A_FIND_REF@la1n40en.hlp>Overview
3 Select Print Preview to see report summaries=H_SELECT_PRINT_PREVIEW_TO_SEE_REPORT_SUMMARIES_REF@la1n40en.hlp>Overview